Stop Excel from Adding Values in a Stacked Column Chart

Fujirich

Active Member
Joined
May 1, 2003
Messages
320
This probably has some simple fix, but I haven't found it yet...

How do I use the Stacked Column chart and stop Excel from adding the values together?

Here's an example of the data...

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>K</th><th>L</th><th>M</th><th>N</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">DSM</td><td style=";">Q3</td><td style=";">YTD</td><td style=";">FY F'cast</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Cohara</td><td style="text-align: right;;">0</td><td style="text-align: right;;">2</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Fisher</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">6</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Jay</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Verkem</td><td style="text-align: right;;">0</td><td style="text-align: right;;">3</td><td style="text-align: right;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Wiley</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Others</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4</td><td style="text-align: right;;">8</td></tr></tbody></table><p style="width:10.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Biz Review Graphs</p><br /><br />

So when I generate a chart using the stacked column option, I want the Cohara line to have zero for Q3, show 2 for YTD, and 6 for FY F'cast. What I get is 0 for Q3 (as you'd expect), 2 for YTD, and 8 for FY F'cast. It's adding the values to come up with the total height of the column, but I don't want that.

Same for the Fisher column. That one gives me a column height 15 tall, but I don't want that. I want it 6 tall based on the values in the N column.

So how do I stop Excel from adding these values and just stack them as they are?

Hope all this makes sense - thanks to anyone who can provide ideas!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,067
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you don't add them, it's not actually a stacked column. You could either use a clustered column chart instead, or add a couple of columns to calculate the differences between each column and the running total so that you can plot that as a stacked column.
 

Fujirich

Active Member
Joined
May 1, 2003
Messages
320
Thanks Rory! Didn't think about your point of it no longer being a stacked column - doh!

Clustered columns are busier looking than I'd like, but maybe my only option

Playing with some of the 3D options but nothing ideal jumps up there either - arrrgh!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,915
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top