Graph error

[Aietoe]

Hi!
I have a graph showing amounts over 3 years
A table holds the relevant data as follows:

Months Amount
1999-07 1000
1999-09 200
2000-01 600
2000-03 800

The x-axis is the amounts from 0 to 1000
The y-axis is holding the months.

The graph looks like this:



1000 x
800 . . x
600 . . x
400 . . .
200 x
0 9907 9908 9909 9910 9911 9912 0001 0002 0003

Since i do not have values for the months of 9908 9910 9912
and 0001, it doesn't show a value of 0 for these months but shows a curve like if these months do not exist.
Is there a way that i can force a value of zero if the data is absent.

Thanks

Aietoe

 

[DallasAggie]

1. Double click to open your chart in design mode.
2. Go to tools
3. Options
4. Chart
5. Click on Interpolated
6. Cheers!

 

[Aietoe]

Thanks a lot, it was not evident...


Aietoe