Trendline to ignore empty cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on an Excel spreadsheet that contains 5 sheets of graphs and 5
or 6 sheets of data. I am trying to not show the trendline when a cell is
empty. I have found a couple of threads about this but do not quite
understand them and would appreciate your help!

Most of them refer to the NA() function but I am not sure where to enter
that and have it reflect in my chart.

I have an average price sheet that contains my total sales for each week and
some of those cells are empty. What would I enter into those empty cells so
they will not show on the trendline in my chart?

Thanks for your help!
 
IN the sales column cells, in place of blanks cells type =NA()
This is display as #N/A
The chart will extrapolate the values for 'empty' data
best wishes
 
This still shows the trendline although the trendline is not at zero. Is
their a way for the trendline to not show at all in that area of the chart?

Thanks for your help!
 
Back
Top