line chart with NA() values

  • Thread starter Thread starter grime
  • Start date Start date
G

grime

12 month line chart, with some values being 0.

I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).

My problem arises when the 0 values fall in the middle of my data.

So for example:
1) data for all months (Jan-Dec), the line shows across all 12
months;
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).

Any suggestions?
 
There is not cell value that behaves exactly like an empty cell. You
can delete the cell formulas (if a dynamic chart you could write a macro
to delete or restore the formula as apprpriate).

Jerry
 
Awesome workaround, and good additional information there. Thanks fo
passing this one along
 
Back
Top