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.

Hi Leirikello,

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

Ed Ferrero
www.edferrero.com


"Leirikello" wrote in message
...
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.

On Jul 23, 5:10*pm, "Ed Ferrero" wrote:
Hi Leirikello,

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

Ed Ferrerowww.edferrero.com

"Leirikello" wrote in message

...

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 thecolorof
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 thecoloreach individual column one by
one?

Thanks for your help.

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?