stacked area series problem
Posted: Fri Apr 25, 2008 9:01 pm
I am having a stacked area series problem--the series appear different depending upon the order I create them.
Here is an image of a chart when I create "Account #1' before "Account #2":
What works in this chart is the way Account #2 starts in year 4--that is what I want. What I don't like is (a) the way account #1 finishes (should be blocked, not slanted); and (b) I want a continuous line going from year 3 to 4, not the drop off and the block start.
In this example, year 3's values for Act 1 and 2 respectively are ~ (100, 0). Years 4 values are ~(50, 50). I want the line to be level, not slanted down as it appears.
If I change the order they were created, I get a different start/finish to the two series:
Account #2 changes the way it starts (I wish it was blocked) and again, there is a dip in year 4.
Is there a way to do this?
My demo was created with the code in the link below:
http://www.RetireNeeds.com/misc/StackedAreaSeries.zip
Ed Dressel
Here is an image of a chart when I create "Account #1' before "Account #2":
What works in this chart is the way Account #2 starts in year 4--that is what I want. What I don't like is (a) the way account #1 finishes (should be blocked, not slanted); and (b) I want a continuous line going from year 3 to 4, not the drop off and the block start.
In this example, year 3's values for Act 1 and 2 respectively are ~ (100, 0). Years 4 values are ~(50, 50). I want the line to be level, not slanted down as it appears.
If I change the order they were created, I get a different start/finish to the two series:
Account #2 changes the way it starts (I wish it was blocked) and again, there is a dip in year 4.
Is there a way to do this?
My demo was created with the code in the link below:
http://www.RetireNeeds.com/misc/StackedAreaSeries.zip
Ed Dressel