Chart Axis to show every value between 1 to n
Hi. I have a dataset that produces the following resultset
Day Count
6 10
7 82
8 89
9 216
10 1392
11 156
14 255
15 114
16 109
17 13
18 14
22 4
I would like the x-axis to show all values 1 - 31, and a corresponding 0 y-value when no data is found.
Despite tinkering with the Interval, IntervalOffset, MajorGridlines, Scale, etc... I'm sure this is an easy adjustment.
Or do I have to alter my dataset to include the 0-counts?
April 15th, 2011 10:58am
Aha! I set the minimum and maximum, but I was missing the Scalar = True property
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2011 1:03pm
Hi,
To set this select the Right click on Horizantal Axis and select Horizantal Axis properties and then on Axis Option tab select Axis Type as "Scalar (Numbers/Dates)"- Chintak (My Blog)
April 15th, 2011 3:56pm