PDA

View Full Version : Solved: Chart with multiple x-axis labels



Saladsamurai
12-18-2009, 07:24 AM
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:

http://i12.photobucket.com/albums/a220/saladsamurai/chart.jpg

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. :banghead:

Could someone help me out on this? :help Thanks!

p45cal
12-18-2009, 10:43 AM
like this?2486

Saladsamurai
12-18-2009, 11:05 AM
like this?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
12-18-2009, 11:42 AM
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..
2488

tpoynton
12-18-2009, 11:44 AM
you can format data points in a series...

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

Saladsamurai
12-18-2009, 11:53 AM
Oh hell yeah.

Thanks a bunch guys!