Solved: Chart with multiple x-axis labels

[Saladsamurai]

I am having a hell of a time with this.

I cannot figure out the Chart insert logic for the life of me.

In the attached workbook, I have a very small table that looks like this:



I would like to make a Column graph. There should be 4 Columns, each a different color, and each with the respective label under them. That is, there should be a column that goes to 12% and it says "Root Mean Square Error" directly below it; one that goes to 43% with "No. of times...(color)"...etc.

If possible, I would like the columns to 'not touch.'

I have tried many different combinations of series and such to no avail.

Could someone help me out on this? Thanks!

[p45cal]

like this?Attachment 2486

[Saladsamurai]

like this?Attachment 2486

I might have to say 'close enough' on this one. I really wanted each column to have it's own unique color. But since they are all technically the same 'series' formatting one will format them all.

[p45cal]

I might have to say 'close enough' on this one. I really wanted each column to have it's own unique color. But since they are all technically the same 'series' formatting one will format them all.

You can, click on a bar on the chart, wait a second, then click again and you have selected just that data point. Now right click and format it as you will..
Attachment 2488

[tpoynton]

you can format data points in a series...

EDIT - p45cal's post was not there when I started replying

[Saladsamurai]

Oh hell yeah.

Thanks a bunch guys!