How to create a stacked chart of three series which stacks only two of them

**tsiddiq23** · 02-10-2013, 07:59 PM

Hi,
Can you please help in creating a mixed stacked chart. I have three series data and want to make a chart which will stack two of them while keeping the 3rd bar alongside in the same month.

Jan Feb Mar Apr May Jun
Series1 1 2 3 3 2 2
Series2 2 2 3 2 1 1
Series3 1 1 2 2 3 3

Thanks for your help.
Regards,
Tahir

**Brumbot** · 02-11-2013, 04:39 AM

Hi tsiddiq23,

You can achieve this by plotting all 3 as a stack chart initially and then right clicking on the series you want to change and going to change series chart type. Change this to a regular bar chart. Voila.

Hope this helps.

How to create a stacked chart of three series which stacks only two of them

LinkBack

Thread Tools

Rate This Thread

Display

How to create a stacked chart of three series which stacks only two of them

Re: How to create a stacked chart of three series which stacks only two of them

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions