Number Formats

K

Kyle

Hello.. I have a chart generated with ASP using a SQL Recordset bound to
the chart. The field format in the DB is "money" and includes the decimal.
When the chart is created the Axis labels do not include the decmial. It
will show 389 instead of 389.45. I have set the NumberFormat property for
the axis but it does not seem to make any difference. Also I can't seem to
make the border disappear.

Ideas? Thank you!

<code>
With m_cspace.Charts(0)
.PlotArea.Interior.Color = "Silver"
m_cspace.Interior.Color = "White"
.Border.weight = 0

'Price Axis (X)
.Axes(0).HasAutoMinorUnit = True
.Axes(0).NumberFormat= "$###.##"
.Axes(0).HasMinorGridlines=true
.Axes(0).MinorUnit= .50

'Time Axis (Y)
.Axes(1).MinorUnit = 1
'.Axes(1).HasMajorGridlines =true
'.Axes(1).MinorGridlines.Line.Color = "RED"
.Axes(1).TickMarkSpacing = 1
.Axes(1).TickLabelSpacing=2
End With
</code>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top