Stacked Area Graph

[Kavy]

Hello,
I have a stacked area graph, with dates on the x-axis. I have =N/A() for the dates with no data points. This worked great when I had a line graph, but when I create a stacked area graph with the same data, with a 'date axis', the stacked area graph plots it, but somehow inverts the area blocks (i.e. I have a white space at the bottom of the graph, and a solid color at the top).

Does anyone have any suggestions?

Thank you!

Kavy

 

[Steve=True]

Everytime there is a break in the data, you can put that data on a new row.

http://www.andypope.info/charts/stackside.htm

My stacked sample looked like a V when i had na()

move the data below after the break creates a break in the graph.

kinda like this and graph the whole thing
a b c d
row 1 10 10
row 2 20 20
row 3 10
row 4 20