Hi
I have five years of data and the x axis is set for 6 years to allow the
chart to fill up as new data is input. When I add a trendline it seems to
include these empty cells. In fact, the cells contain a formula but have
managed to get the data plot to not be zero by using the NA() function which
I found in another thread. Any ideas how I can get the trendline to only use
the actual data for its calc rather than plotting along the whole of the x
axis?
Much appreciate your advice
Keith