G
germullen
Hi
I am plotting data such as the following on a simple line chart...
Jan Feb Mar Apr May June
10 11 12 0 0 0
The future month (Apr, May , June) each contain a formula which return
either zero or "" as no data is available.
The problem is that I don't want the future months to be plotted a
zero, which is what happens. There is an option in Excel to avoi
plotting 'empty' cells - but these cells are not empty as they contai
a formula.
Of course, I could simply choose Jan:Mar as the chart range and updat
it each month, but I know I'll forget to do it. Alternatively, I coul
delete the formula and paste them in each month, but that's stil
relying on me to remember.
Thank
I am plotting data such as the following on a simple line chart...
Jan Feb Mar Apr May June
10 11 12 0 0 0
The future month (Apr, May , June) each contain a formula which return
either zero or "" as no data is available.
The problem is that I don't want the future months to be plotted a
zero, which is what happens. There is an option in Excel to avoi
plotting 'empty' cells - but these cells are not empty as they contai
a formula.
Of course, I could simply choose Jan:Mar as the chart range and updat
it each month, but I know I'll forget to do it. Alternatively, I coul
delete the formula and paste them in each month, but that's stil
relying on me to remember.
Thank