How to create stacked line chart with some empty value?



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



Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question