Have a look he
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cathy" wrote in message
...
hi, I am a mining analyst... I want to plot a column chart, sorted
according
to share price performance, but with the bars colored according to the
commodity the company is associated with... is this possible?