Trend line

[S]

On one of my graphs I have the following information................

weeks 1 - 13
For weeks say 1 - 6 I have £ values.
I have a trend line in place but because values are not in for weeks 7 - 13
the trend line goes into a minus.
Is there a way to stop this? I would ideally only like to see the trend on
the weeks where a value is entered.

thanks

--

 

[Bernard Liengme]

In the places where you have no data enter =NA()
This shows as #N/A and is ignored by the chart
Just replace each one as data come sit
best wishes