Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 104
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 99
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 104
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 104
Default excel chart problem

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

cathy


  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
different colors for bars in a column chart KRK New Users to Excel 2 March 15th 09 04:16 PM
SUMIF formula required to search for 2 diff values in 2 diff colum Lidy693 Excel Worksheet Functions 7 February 21st 09 09:45 PM
how you make links between diff. cells on diff. work sheets NYC-MIKE Excel Worksheet Functions 3 February 11th 08 05:05 PM
Excel should allow two or more cell painters set to diff colors Bill C Excel Discussion (Misc queries) 0 March 27th 06 10:56 PM
Excel should allow two or more cell painters set to diff colors Bill C Excel Discussion (Misc queries) 0 March 27th 06 10:56 PM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"