Set Limit for Line Graph

[krais]

I am trying to create the line graph in excel 2003 ( Forcast
/Budget/Year)
I have formulas on each rows and each cells.
When I plot the line graph the lines doesn't stays at it's end value (
let say 100,
last value) line drop to zero if the next month has no value ( blanks
or space )
I want to limit lines where it touch end or last value (let say 100 )
without droping to zero.

Please advise
Regards

 

[Guest]

See if this helps... choose the chart (click on it). From the menu bar
choose Tools | Options and then choose the [Chart] tab. There are options
there for how the currently chosen chart handles empty cells. See if one of
the other options than the one currently in use gives you better looking
results.