Bar Chart, Trend Line, Zero Value

[srizki]

How can I stop trend line at August, I have September forcast bar in chart, actuals trend line goes upto August and then fall to zero in September because there are no actuals for September yet. How can I avoid trend line to go to September.

Thanks

 

[Steve=True]

Hi Sriziki

I would suggest changing your Zero data points to equal NA()

This should modify your trendline to ignore the Zero data points.

Here is visual and a link on how to use NA():

Using NA(): http://www.exceldashboardtemplates.com/?p=696

Hope this works for what you are trying to do.

Steve=True

 

[srizki]

Thank you very much Steve.