Using MSChart for .NET Environment
I'm trying to create a Column chart
I have the data in a dataset and plot the columns as
For Each rRow In objDS.Tables("dtChart").Rows
Chart1.Series("Series1").Points.AddY(rRow("totcountstatus"))
Chart1.Series("Series1").Points(Chart1.Series("Series1").Points.Count - 1).Label = rRow("totcountstatus")
Chart1.Series("Series1").Points(Chart1.Series("Series1").Points.Count - 1).AxisLabel = rRow("status")
Next
This displays (almost) the chart I need
The immediate problem is there are vertical grid lines created on the chart and they run through the center of the columns. I'm wondering how to supress the display of those lines.
The second problem happens when there are more than 9 columns. They all display properly, but the AxisLabel appears only where there is a grid line. And there are fewer than "ColumnCount" lines in the display. (I haven't figured out how many lines there actually are based on the number of columns). Is there some way to control how many of those lines will appear in the chart so that each column can have its own AxisLabel.
Thanks to all............Rich