Only alternate data points plottedon Y axis in chart

[Former Member]

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

Totally lost

What may I be doing wrong?

Please help!

[Former Member · Accepted solution]

Hi Dan

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.

Thanks

Poonam Thorat

[Former Member · Accepted solution]

Ok, I think I now know what the problem is, but I still don't know how to fix it

I have YTD for current yr and last yr; so for each month the data is

1 1000

1 0

2 0

2 2000

3 3000

3 0

etc

The 0 is because the info is only for the current yr; if I look at the data for last yr, I get values like

1 0

1 100

2 200

2 0

3 0

3 300

etc

So the "when month changes" ytd running total is only calculating when the counter changes, so I get

1 - 1000

2 - 1000 (since it misses the 2nd row for month 2)

3 - 3000

etc

any ideas on how to make the YTD running total to calculate the combined sum of row 2 (0+2000 = 2000)?

Hope I explained my problem clearly

Thanks

[Former Member]

I am using CR 8.5