If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart Colors
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. |
#2
|
|||
|
|||
Chart Colors
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. |
#3
|
|||
|
|||
Chart Colors
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? |
Thread Tools | |
Display Modes | |
|
|