I want to show gaps in my line chart

Originally Posted by rshackleford310

I want to show gaps in my line chart. For example, say I have the following sales days and amounts:

Day Amount
1 $100
2
3 $140
4 $150

When I plot this information, day 2 is treated as a "0" and it pulls the line plot down. I want this value treated as an empty cell so that no information for that day is plotted and there is a gap in the line plot.

The problem is that I have a formula written in the "Amount" column to pull sales $s for the corresponding day. I want to leave the formula in there to keep the spreadsheet dynamic. I've tried writing error formulas that will produce a blank ("") for empty cells, but those cells are still treated and plotted as a "0"s.

The only way I know how to eliminate the problem is the manually delete the cells with no sales dollars (i.e. not even the formula remains), but I want to avoid that to keep the process automatic.

Hi,

with the chart selected, Tools, Options, Chart, and check the Not Plotted Leave Gaps.

Let me know how you go.
---