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>
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
 
Upvote 0
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>
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,710
Members
448,293
Latest member
jin kazuya

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
Back
Top