plotting column chart whch colors the bars diff for diff comm
 

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?

plotting column chart whch colors the bars diff for diff comm
 

Hi Cathy,

I'm sure this is possible.
Can you provide an example of your data and it's layout, so we have
something to work with?

Dave

"Cathy" wrote:

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?

plotting column chart whch colors the bars diff for diff comm
 

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?

plotting column chart whch colors the bars diff for diff comm
 

hi dave what is is is the relative performance of about 20 companies... some
gold, some copper, some silver etc, so i want the bars to show the actual
performance, but the bars to be colored relative to the metal
so for example if I had
SAR - gold co
EQN copper
HIG gold
Hav copper
CQT silver

the bars would be colored according to their underlying commodity..
I could send you an example if I could work out how to send you an email

"Dave Curtis" wrote:

Hi Cathy,

I'm sure this is possible.
Can you provide an example of your data and it's layout, so we have
something to work with?

Dave

"Cathy" wrote:

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?

excel chart problem
 

hi i sent an email to you showing the issue
regardsand thanks

cathy

excel chart problem
 

Did not get email from you. Did you remove TRUENORTH. from the address as
required?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cathy" wrote in message
...
hi i sent an email to you showing the issue
regardsand thanks

cathy