How stop graphic descend

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

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

Formula:

Please Login or Register  to view this content.

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.