Only alternate data points plottedon Y axis in chart
I have a chart with "On change of" set to "Month" with the Y axis set to YTD earnings for the month. However, the chart only plots data points for 1,3,5.... skipping 2,4,6...
What may I be doing wrong?
Please try the following steps:
1) Right Click on the any Y-axis value and select Chart Otpions -> Grids.
2) In the Numeric Axis Grids & Scales go to Scales tab and check the "Use Manual Stting for" option.
3) Depending on the Maximum Value we will be able to edit the Grids value.
4) After making the maximum value say 25, go to Grids tab and in the Major Gridlines use the Interval Value to 1.
After making the changes you will see the data points for 2,4,6,... as well.
Hope this help.