Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Graph error

Status
Not open for further replies.

Aietoe

Technical User
Nov 30, 2000
85
CA
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
 
1. Double click to open your chart in design mode.
2. Go to tools
3. Options
4. Chart
5. Click on Interpolated
6. Cheers! :)

 
Thanks a lot, it was not evident...


Aietoe
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top