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?

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?

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