How stop graphic descend

[vasc]

Hi my friends...

In my graph cell aa297 is last with data
how learn excel to let line horizontaly to value 279
Now line get down to 0


any ideea pls...

[Kaper]

One of the options could be to use series based on such modified values:

=IF(AA3<>0,AA3,NA())

and changing card type to scatterplot

Other will be by creating dynamic graph using only filled cells for series
See for instance https://peltiertech.com/Excel/Charts...umnChart1.html
It's shown on column type graph, but the same technique could be used for line graph.

[vasc]

Briliant my friends..
thanks

Solved