on 02-22-2011 2:31 PM
Hi,
I tried to find the answer at old posting, but failed to find proper solution.
So here I go again with the same old problems:
1. Any method / trick to display total on top of each stacked column ?
(Label is not an option, since it is static and will not move following the height of the stacked bar).
2. Any method / trick to combine stacked column chart with line chart ?
(Overlay is not an option, because I think it is too tedious to play around with color and border)
Thanks for the bandwidth.
Regards.
NB: Are there any XCelcius add-on for those 2 functions ?
Hi Yudie,
Can you get compromised in the following way ?
In the X Axis labels, you can get the values concatenated dynamically and displayed. Example given below:
2008 2009 2010
P180 P250 P280
A172 A263 A265
Whereas P denotes to Plan and A denodes Actuals. Above to this labels stacked colum wil be there as usual.
Consider and revert, in case you need any more clarification on this.
Keep posting.
With best wishes
BaaRaa.
Edited by: Baskar Rajagopalan on Feb 23, 2011 3:36 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you thought of using a Combination Chart as an alternative? Your bars wouldn't be stacked, but they'd still be comparable from a viewing perspective since they'd be right next to each other for each occurance on the X-Axis. You could then use the chart's 2nd Y-Axis feature to plot your Total line on top of the bars.
I was toying around with the Stacked Column Chart as well but can't seem to find a solution you're looking for.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
A stacked column chart allows you to compare several variables over a period of time by adding one dimension on top of another. these types aof charts are ideal whe comparing several dimensions over a period of time. the dual axis feature allows you to plot a series on either the primary or secondary axis with this chart
All the best, Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.