cancel
Showing results for 
Search instead for 
Did you mean: 

Stacked Column Chart (Total and Combination Chart)

Former Member
0 Kudos

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 ?

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member610149
Active Participant
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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