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

**smilewithme** · 11-19-2009, 05:26 AM

Many thanks Teylyn.

**peterputter** · 08-02-2012, 09:13 AM

Unfortunately this data layout is not in a format in which I can extract data. The attached sheet shows time data (in seconds of a day) for a number of julian days which are separated by a value which I want to become that particular bar color, of which there will only be three in total (Red=1, Yellow=2, and Green=3). Included within the sheet is a Chart1 tab... I welcome all suggestions!

**arlu1201** · 08-03-2012, 04:55 AM

Peter,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**peterputter** · 08-03-2012, 08:39 AM

NP... many other forums berate posters for NOT searching other threads for similar information or solutions. I didn't want to start a new one since this was related and wasn't too long. Alas, I'll post a new thread with my question. Thank you for your comments.