Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
hi i sent an email to you showing the issue
regardsand thanks cathy |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
different colors for bars in a column chart | New Users to Excel | |||
SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Excel should allow two or more cell painters set to diff colors | Excel Discussion (Misc queries) | |||
Excel should allow two or more cell painters set to diff colors | Excel Discussion (Misc queries) |