Jump to content
Fórum Script Brasil
  • 0

Mschart - formatar labels do Eixo Y


Señor Smoke

Question

Olá a todos.

Estou preenchendo um grafico(mschart) com os dados de um recordset.

Eu preciso formatar os labels do eixo Y (Axis Y). Os meus valores no eixo Y devem ser em moeda (1.000,00) mas quando jogo os valores no grafico eles ficam dessa forma :

exemplo: 188e+11 algo do tipo.

Como posso formatar os labels de forma q eles fiquem no formato que eu preciso?

Segue o trecho do codigo que preenche o grafico:

'Preenchendo grafico

Dim rc2 As rdoResultset

Set rc2 = rdocn.OpenResultset(SQL)

reg = 4

MSChart1.chartType = 1

MSChart1.ShowLegend = False

MSChart1.Title = "Evolução do Período"

MSChart1.ColumnCount = 1

MSChart1.RowCount = reg

MSChart1.Visible = True

While Not rc2.EOF

For i = 1 To reg

MSChart1.Row = i

MSChart1.RowLabel = rc2("qtd_reg")

MSChart1.Data = rc2("vl_pr_pago")

rc2.MoveNext

Next

Wend

rc2.Close

Obrigado!

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      652k
×
×
  • Create New...