Hi all -
I have an interactive chart displaying stacked area charts for 2006 and 2007
I currently have 2006 in front of 2007, but as the user chooses 1 of 20 units, it will look better to move 2007 in front of 2006
Can this be done using vba or formula?
Thanks
-marc
Re: Stacked Area Charts Most Data Points In Front
If you have stacked area then the series would be on top of not in front of.
And swapping series would probably confuse most people.
Can you post and example of your chart?
Re: Swap Series In Stacked Area Chart
Thanks Andy
I haven't been able to get the workbook small enough to post
PM me with your e-mail address if you would like to see the workbook
I have attached a sample chart where I think it would look better to move 2007 (Red) in front of 2006 (Blue).
This is an interactive chart, where user only sees 1 chart at a time. I agree, if there were multiple reports it may be confusing to jump back and forth.
Thanks
-marc
Re: Swap Series In Stacked Area Chart
Is area the correct chart type to use then if there is a possibility of data obscuring data?[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Rather than using area charts try using column charts.
2007 columns can be put on the secondary axis. This will make them appear in front of 2006.
So in order to see 2006 data when the value is less than 2007 reduce the gapwidth so the columns are fatter.
As for the labels colliding with the data line the only way to stop this is to position the labels completely away from the line. Either position at base or use another series to position the labels in a static place with linked data labels.
Re: Swap Series In Stacked Area Chart
Thanks Andy -
I'll give it a go and come back on the column charts
My instinct is that it will appear busy
I also like that the trend and ytd avg are different chart types and makes each visually appealing in their own right, even though they appear on the same chart
Thanks much
-marc
Don’t have an account yet? Register yourself now and be a part of our community!
