color bars in chart with code?

's Computer Specifications

I have data laid out in 3 columns... date in the first, a number in the
second,and a color (Green, Red, or Blue) in the next. I have a chart with
floating bars and would like them to be the color of the color in column
three. Can I do that with code? Is there a better way?

's Computer Specifications

Answered in the charting group.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"John" <(E-Mail Removed)> wrote in message
news:E0511862-1193-4189-BABD-(E-Mail Removed)...
>I have data laid out in 3 columns... date in the first, a number in the
> second,and a color (Green, Red, or Blue) in the next. I have a chart with
> floating bars and would like them to be the color of the color in column
> three. Can I do that with code? Is there a better way?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I change the color of the bars in a Bar Chart?	CarolynMarCom	Microsoft Powerpoint	2	6th Aug 2009 11:54 PM
Customise error bars on individual bars in a bar chart 2007	Millie	Microsoft Excel Charting	2	25th Apr 2009 04:16 AM
Format Chart Bars with code?	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Charting	3	21st Mar 2007 08:58 PM
Make a line in a bar chart, and change color of any bars that exceed the line	MarkM	Microsoft Excel Misc	4	5th Jul 2006 04:06 PM
Color of bars in chart to be determined by a condition	Ben	Microsoft Excel Charting	1	11th Dec 2003 06:27 PM