Hi,
I have a chart that displays the qty (y axis) against salesperson (x axis).
The problem i am having is, when the hightest qty is a low number (eg; 2) the major ticks shown are 0.2, 0.4, 0.6 etc...
I dont want this, i just want whole numbers to be shown.
I cant use autoscale (i assume this) as i dont know what the qty will be until the chart is generated.
Can you please help ?
Thanks
Mark
I have a chart that displays the qty (y axis) against salesperson (x axis).
The problem i am having is, when the hightest qty is a low number (eg; 2) the major ticks shown are 0.2, 0.4, 0.6 etc...
I dont want this, i just want whole numbers to be shown.
I cant use autoscale (i assume this) as i dont know what the qty will be until the chart is generated.
Can you please help ?
Thanks
Mark