Bar Graph with different colours ............

sanjkhanna · May 21st, 2002, 02:12 AM

I am only a beginner to intermediate level user of excel :

Can we generate a bar graph with bar patterns/colours to represent values - e.g for values between 0 to 100 can you have 3 different cours e.g for 0 to 50 red, 51-75 yellow, 76-100 green.

(I have a similar task where I am supposed to make 55 graphs - each having 10+ bars and I have to manually change to the 3 reqd colours on each bar of the graph unless there is a solution to this)
thanks

Damon Ostrander · May 21st, 2002, 09:03 AM

Hello sanjkhanna,

Yes, this is not difficult to do, but requires a few lines of VBA code. Rather than trying to explain it here, if you will post your email address I will be happy to send you an example of a bar chart in which the bar colors are based on the value being plotted.

sanjkhanna · May 21st, 2002, 05:05 PM

Dear Damon

Thanks a ton for the prompt reply
My email add is

sanjay.khanna@gecrps.com.au

I am glad there is a solution, although it requires coding in VB. When u respond with that code it'd be great if u could tell me how to use/implement that code too.

Thanks and best regards

Damon Ostrander · May 22nd, 2002, 11:04 AM

Its on its way.

Damon

May 21st, 2002, 09:03 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hello sanjkhanna, Yes, this is not difficult to do, but requires a few lines of VBA code. Rather than trying to explain it here, if you will post your email address I will be happy to send you an example of a bar chart in which the bar colors are based on the value being plotted. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

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

May 21st, 2002, 02:12 AM	#1
sanjkhanna New Member Join Date: May 2002 Posts: 2	I am only a beginner to intermediate level user of excel : Can we generate a bar graph with bar patterns/colours to represent values - e.g for values between 0 to 100 can you have 3 different cours e.g for 0 to 50 red, 51-75 yellow, 76-100 green. (I have a similar task where I am supposed to make 55 graphs - each having 10+ bars and I have to manually change to the 3 reqd colours on each bar of the graph unless there is a solution to this) thanks

May 21st, 2002, 05:05 PM	#3
sanjkhanna New Member Join Date: May 2002 Posts: 2	Dear Damon Thanks a ton for the prompt reply My email add is sanjay.khanna@gecrps.com.au I am glad there is a solution, although it requires coding in VB. When u respond with that code it'd be great if u could tell me how to use/implement that code too. Thanks and best regards

May 22nd, 2002, 11:04 AM	#4
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Its on its way. Damon