Applying progressive color gradient on bar charts

[rickcb]

I'm trying to apply a conditional gradient fill inside the bars of a bar chart to illustrate differences in temperature based on position. Blue shades for the coldest temperature and red shades for the hottest.

Data is set up in this way:
Column A1:A6 contains the positions (6 positions)
Column B1:B:6 contains the temperature readings (1 reading per position)

Any ideas on how this can be done?

Thanks for your help

 

[VoG]

This doesn't create a color gradient but may give you some ideas http://peltiertech.com/Excel/Charts/ConditionalChart1.html

 

[rickcb]

Peter,
This way would be a little hard to do as the "limits" for the gradient will vary depending on the range of values.

Thanks,

 

[pbornemeier]

This post has a link, which I have not yet looked at and an example that you may be able to adapt:
http://www.mrexcel.com/forum/showthread.php?t=271525