Changing bar colors in Graphs automatically ??

jmmarsh · Mar 30th, 2004, 07:23 PM

I have a director looking to get this done and none of us here have any idea. Say you have a bar graph with months across the bottom and dollar figures on the left side (up to $100,000) and you want to specify ranges, for example if any month is between $10,000 and $20,000 you want that bar in the graph to be red - if any month is between $21,000 and $30,000 you want that bar in the graph to be blue, etc. etc. Can this be done?

CT Witter · Mar 30th, 2004, 09:12 PM

Check out Jon Peltier's site : http://peltiertech.com/Excel/Charts/format.html

The ones you want are probably the Simple Conditional Charts & Simple Conditional Charts 2.

HTH,
CT

jmmarsh · Mar 31st, 2004, 04:12 AM

Thank you so much from everyone here in the office :D!!!!

Mar 30th, 2004, 07:23 PM	#1
jmmarsh Join Date: May 2002 Posts: 32	Changing bar colors in Graphs automatically ?? I have a director looking to get this done and none of us here have any idea. Say you have a bar graph with months across the bottom and dollar figures on the left side (up to $100,000) and you want to specify ranges, for example if any month is between $10,000 and $20,000 you want that bar in the graph to be red - if any month is between $21,000 and $30,000 you want that bar in the graph to be blue, etc. etc. Can this be done?

Mar 30th, 2004, 09:12 PM	#2
CT Witter MrExcel MVP Join Date: Jul 2002 Location: Columbus, OH Posts: 1,170	Re: Changing bar colors in Graphs automatically ?? Check out Jon Peltier's site : http://peltiertech.com/Excel/Charts/format.html The ones you want are probably the Simple Conditional Charts & Simple Conditional Charts 2. HTH, CT

Mar 31st, 2004, 04:12 AM	#3
jmmarsh Join Date: May 2002 Posts: 32	Re: Changing bar colors in Graphs automatically ?? Thank you so much from everyone here in the office :D!!!!

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