I need to create a bar chart for the year. I've already have 3 bars for each of the months, a plan, an actual, and a last year. I need to be able to split out just the actual bar, so that it is a stacked bar. The other two bars need to stay and remain unstacked. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
A Bar chart with mutiple bars, but just 1 is stacked
- Thread starter RGH
- Start date
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Yes this is possible.
Check out Jon Peltier's website - this link shows how to do something that is effectively the same as what you want. http://www.peltiertech.com/Excel/Charts/NonNative.html#ClusterStack
Check out Jon Peltier's website - this link shows how to do something that is effectively the same as what you want. http://www.peltiertech.com/Excel/Charts/NonNative.html#ClusterStack
Upvote
0
Ysabelle_etc
New Member
- Joined
- Nov 17, 2013
- Messages
- 1
Can you help to show me how you do it?
I have a data as shown below
| coffee | sugar | milk | cookies | ||
| 3in1 | 2in1 | ||||
| Q1 | 0 | 0 | 0 | 0 | 0 |
| Q2 | 1 | 3 | 13 | 13 | 3 |
| Q3 | 18 | 45 | 65 | 68 | 69 |
| Q4 | 9 | 27 | 25 | 22 | 31 |
<tbody>
</tbody>
And i want to have 4bars for coffee, sugar, milk and cookies BUT the coffee needs to be stacked so that it will show the 3in1 and 2in1
Thanks in advance
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Set out your data like this:
Plot as a Clustered Column Chart. Move coffee 3in1 and coffee 2in1 to the Secondary Axis and change their Chart type to Stacked column. Here's an sample workbook:
https://app.box.com/s/lfqa9tjv8c98etws607c
| Excel 2010 | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | coffee | sugar | milk | cookies | ||||
| 2 | 3in1 | 2in1 | ||||||
| 3 | Q1 | 0 | 0 | |||||
| 4 | 0 | 0 | 0 | |||||
| 5 | Q2 | 1 | 3 | |||||
| 6 | 13 | 13 | 3 | |||||
| 7 | Q3 | 18 | 45 | |||||
| 8 | 65 | 68 | 69 | |||||
| 9 | Q4 | 9 | 27 | |||||
| 10 | 25 | 22 | 31 | |||||
Sheet1 | ||||||||
Plot as a Clustered Column Chart. Move coffee 3in1 and coffee 2in1 to the Secondary Axis and change their Chart type to Stacked column. Here's an sample workbook:
https://app.box.com/s/lfqa9tjv8c98etws607c
Upvote
0
Similar threads
- Question
- Question
