Chart Colors

[Leirikello]

This one's got me stumped.

I just officiated a test, and would like to make a chart showing 3 different
pieces of information:

1. The person's name shown horizontally <--->
2. The person's score shown vertically |
3. The person's exposure time to the subject, shown by the color of their
bar (ex: green = brand new / black = very experienced, with shades in between)


I know there is a conditional formatting function that does this for cells,
but is there any function that is able to do this for charts, or do I simply
have to go through and hand-pick the color each individual column one by one?

Thanks for your help.

 

[Ed Ferrero]

Hi Leirikello,

Go to
http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx
look for 'Conditional Format Bar Chart'

Ed Ferrero
www.edferrero.com

 

[JFolsom]

Hi Leirikello,

Go tohttp://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx
look for 'Conditional Format Bar Chart'

Ed Ferrerowww.edferrero.com

Is there a way that this can be adapted so that instead of bars, each
type (meat, fish, veggies) can have a line, and the line can be
conditionally formatted to be a certain color based on another
variable..say you added a variable for initial cost?