Multiple groups in X axis

Hi westis,

Have a look at this link - http://peltiertech.com/Excel/Charts/...rts.html#Intro
I think the one you want is - A Real-Life Combination Chart

Hi oldchippy,

Thanks for your reply. From what I understand from that link I'm not sure I can accomplish what I'm after.

It seems like on that page there is one style for each series. But I have all four series in each stack (not sure I use the right words in English, since I use Excel in Swedish). So I'm not sure how I can split the chart up into three sub-charts.

I have attached an example with a chart and its source data. As you can see from there there are three sub-categories in the chart, but the category headers show up as rows just like the rest.

I haven't worked much with charts in Excel and couldn't figure out a way to do this from what I read in the page of that link....

Could you use this one, but change the chart type from a Vertical to a Bar?

http://peltiertech.com/Excel/Charts/StackedCharts.html

Originally Posted by westis

Hi oldchippy,

Thanks for your reply. From what I understand from that link I'm not sure I can accomplish what I'm after.

It seems like on that page there is one style for each series. But I have all four series in each stack (not sure I use the right words in English, since I use Excel in Swedish). So I'm not sure how I can split the chart up into three sub-charts.

I have attached an example with a chart and its source data. As you can see from there there are three sub-categories in the chart, but the category headers show up as rows just like the rest.

I haven't worked much with charts in Excel and couldn't figure out a way to do this from what I read in the page of that link....

Hi,

perhaps the attached might help :added, but you need to reduce C2 C9 & C13 down to 30, I was trying to accomodate the width of the second groupname, to no avail.

---