2 color bar chart?

John · March 22nd, 2006, 06:01 PM posted to microsoft.public.excel.charting

I have a bar chart that has about 30 data points. The Y axis is a value and
the X axis is a name. There are two different possible categories in the X
axis. For example points could be "A 100" or "B 103" or "B 102" ...is it
possible to code the chart so that if a data point's label starts with "A"
format the bar one color... if not format it another?

Thanks for your time and any help you could provide!

John · March 22nd, 2006, 09:47 PM posted to microsoft.public.excel.charting

http://peltiertech.com/Excel/Charts/...nalChart1.html

"John" wrote:

I have a bar chart that has about 30 data points. The Y axis is a value and
the X axis is a name. There are two different possible categories in the X
axis. For example points could be "A 100" or "B 103" or "B 102" ...is it
possible to code the chart so that if a data point's label starts with "A"
format the bar one color... if not format it another?

Thanks for your time and any help you could provide!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pasting chart shows chart area, not the chart	Pirjo	Powerpoint	3	October 13th, 2005 04:31 AM
how to add animation to a chart - make lines appear	David Leonard	Powerpoint	11	June 2nd, 2005 12:33 AM
Urgent Chart Questions	Brent E	General Discussion	0	May 9th, 2005 11:01 PM
Scrollbar on Chart Jumps to Left when Chart is Clicked	Bob	Charts and Charting	5	May 1st, 2005 02:06 AM
build chart template; then add series one by one	L Mehl	Charts and Charting	2	February 12th, 2004 10:53 PM