Column Chart - color based on x value

**smilewithme** · 11-16-2009, 11:49 PM

Hello, I have a table similar to this (attachment - 2 columns and 12 rows).

Here I want to plot A on x axis and B on y axis using column chart. The columns color should be based on the x value (4 unique colors for 4 unique values - P/Q/R/S). How can I do this? I have hundreds of such rows.

Thanks

**teylyn** · 11-17-2009, 12:04 AM

Hi,

it's all about the data layout.

Like this, maybe? See attached

hth

**smilewithme** · 11-19-2009, 02:09 AM

Thanks for help. I want the graph look like this, but I want to -

1. Do it without making another table specifying values of P, Q, R and S
2. Would like to have P, Q, R and S written on x axis

Can you help?

Thanks.

**teylyn** · 11-19-2009, 03:59 AM

Well, then the only way I can see is to create a simple column chart and manually select the color for each data point.

Every other solution will involve the creation of another table to hold the data, unless you find a VBA wiz to write a macro for you.

Data layout is an essential part of chart creation. I've solved your second requirement in the attached file, where you can see that each data label now has its own color. It's like conditional formatting for charts, but you need a helper table to achieve it. (the helper table could be on a different sheet, of course!)

See what you can do with that.

cheers