Stop line chart when values =0 or blank

[mactoolsix]

I'm creating a template, so the data varies from user to user.
I want to include a line chart, however when one user's data stops earlier than another's, the graph ends up with a long line graph of zero.
Is there a way to stop the line graph when the value is zero?

 

[onlyadrafter]

Hello,

One way is to create a different source of data, whereby you have a formula showing #N/A instead of 0

i.e. =IF(B1=0,#N/A,B1)

Graphs don't show for #N/A.

Does this solve your problem?

 

[mactoolsix]

I tried your suggestion. The problem is the chart horizontal axis is years. The possible data contains 2018 through 2099, however some clients only need 2018 to 2050 or 2060. I end up with a graph for 2018 to 2050 and then a blank graph with a flat line from 2050 to 2099 which is about 1/2 the graph. If only 2018 to 2050 is used, I'd like the chart's horizontal axis to span only 2018 - 2050.

Thanks for the suggestion!

 

[mactoolsix]

After a great deal of searching and many attempts, I've found a solution.
Here's a link for anyone interested in how to create a chart (Line or Bar) that will adjust dynamically.

https://peltiertech.com/Excel/Charts/DynamicColumnChart1.html