How to create stacked line chart with some empty value?

  • Thread starter Thread starter q09876
  • Start date Start date
Q

q09876

Hello all:
I have a following data set for excel.

==A1 A2 A3 A4
B1 N 2 5 3
B2 8 N 2 7
B3 4 2 N 6
B4 7 6 4 N

I need to draw a stacked line with series in columns.
But whenever, i use excel to create chart from this dataset,
excel always canot generate the chart style i expect.

For the cells, A1-B1, A2-B2, A3-B3 and A4-B4, no value is available, so
i want excel just ignore those values and continue to
draw the following segments. so the each line out of four should be
divided by the empty value without connection.

How can I implement this with excel?

thank you
-Daniel
 
Daniel -

Leave the cells blank and Excel will break the line. Blank doesn't mean
a formula that returns ""; this will plot like a zero. If you enter
true blanks in these cells (i.e., select each cell and press Delete),
and the chart has no gap, select the chart, go to Options on the Tools
menu, click on the Chart tab, and check the Leave Gaps option for "Chart
Blanks As" at the top.

I don't know what the relevance is in a stacked line chart, once you
lose a data value in the middle....

- Jon
 
Back
Top