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>
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>