Combining a stacked column chart with a clustered chart for historical data

jodava

New Member
Joined
Jan 30, 2015
Messages
3
Hi

I have the following data, and would like to present it in a column chart where the machines (770, X1, Kon, etc) are shown side by side, in each month, but the colour and mono data, for each machine, is stacked.

Is there any way to do this?

Thanks

MachinePrint TypeJul-14Aug-14Sep-14Oct-14Nov-14Dec-14
770colour183,976175,089208,163226,253130,93084,564
mono12,51616,55816,74618,42814,155
X1colour120,957112,856106,276112,776178,934171,000
mono00000
Koncolour456,892163,423500,056506,78700
mono1,41739,33811,13200
Cancolour88243,847269,171207,700
mono19815513,64751,384
2100colour207,227
mono12,087

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,261
It can be done but there are several steps. It requires your data to be rearranged.

Do a web search for something like Excel mixed clustered stacked column chart. You will find several step-by-step guides, videos, tutorials on how to do it.

Here's a good one.
Stacked Cluster Chart
 

jodava

New Member
Joined
Jan 30, 2015
Messages
3
This doesn't work. I tried it out before I posted the question because as soon as I spread the data over two rows, it fails to plot on the chart, although it shows in the legend and the range is correctly selected. Very confused!

770 col770 monKon colKon mon
Apr-14206,15811,717
222,2168,284
May-14219,6563,339

<tbody>
</tbody>
172,67325,900
Jun-14136,99243,031
456,892278,731
Jul-14183,97615,232
163,4231,417
Aug-14175,08912,516
500,05639,338
Sep-14208,16316,558
506,78711,132
Oct-14226,25316,746
00
Nov-14130,93018,428
00
Dec-1484,56414,155
00

<colgroup><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,261
Your Dates as the X-axis set the default X-axis scale to sequential date-time. The X-axis should be set to scale as Category for this to work. Perhaps the tutorial should express that as a caveat.

After creating the stacked chart, right-click on it and select Chart Options. Then on the Axis tab, change the X axis from Automatic to Category.

Then follow the other steps in the tutorial about formatting the gaps and spacing on the chart.
 

jodava

New Member
Joined
Jan 30, 2015
Messages
3
You little beauty!!!! Thanks so much :D
 

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,576
Members
405,410
Latest member
NAnsari

This Week's Hot Topics

Top