Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
I have a worksheet that evaluates the % of a goal. I have it set up as a
chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
Hi Amanda,
There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
"Amanda" wrote in message ... I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
Amanda -
This web site may get you started: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... If they are <1% of the goal, red.....equal to or between -1% & 1% yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
I looked at the link, but I do'n't see how that will help my chart. I only
have one column, not multiples, and I need the color to change based on an outside cell. Also, I can't download the zip file to see how the column chart was created, because it is blocked by my work. Any ideas? Am I wrong that it wouldn't work? "Jon Peltier" wrote: Amanda - This web site may get you started: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... If they are <1% of the goal, red.....equal to or between -1% & 1% yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
I think I figured it out....based on the website you gave me and one other I
found online....however, now there is this ugly table in the middle of my sheet....and when I hide it, it hides my chart....HELP! "Amanda" wrote: I looked at the link, but I do'n't see how that will help my chart. I only have one column, not multiples, and I need the color to change based on an outside cell. Also, I can't download the zip file to see how the column chart was created, because it is blocked by my work. Any ideas? Am I wrong that it wouldn't work? "Jon Peltier" wrote: Amanda - This web site may get you started: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... If they are <1% of the goal, red.....equal to or between -1% & 1% yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
Move the table out of view, or select the chart, go to Tools menu Options
Chart tab, and uncheck Plot Visible Cells Only. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... I think I figured it out....based on the website you gave me and one other I found online....however, now there is this ugly table in the middle of my sheet....and when I hide it, it hides my chart....HELP! "Amanda" wrote: I looked at the link, but I do'n't see how that will help my chart. I only have one column, not multiples, and I need the color to change based on an outside cell. Also, I can't download the zip file to see how the column chart was created, because it is blocked by my work. Any ideas? Am I wrong that it wouldn't work? "Jon Peltier" wrote: Amanda - This web site may get you started: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... If they are <1% of the goal, red.....equal to or between -1% & 1% yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Column Chart and Auto Shape
Thanks! I moved it out of view and it works perfectly. I did not know about
the "Plot visible cells only" that will help on future projects! Thanks again "Jon Peltier" wrote: Move the table out of view, or select the chart, go to Tools menu Options Chart tab, and uncheck Plot Visible Cells Only. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... I think I figured it out....based on the website you gave me and one other I found online....however, now there is this ugly table in the middle of my sheet....and when I hide it, it hides my chart....HELP! "Amanda" wrote: I looked at the link, but I do'n't see how that will help my chart. I only have one column, not multiples, and I need the color to change based on an outside cell. Also, I can't download the zip file to see how the column chart was created, because it is blocked by my work. Any ideas? Am I wrong that it wouldn't work? "Jon Peltier" wrote: Amanda - This web site may get you started: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Amanda" wrote in message ... If they are <1% of the goal, red.....equal to or between -1% & 1% yellow.....and more than 1% green "ShaneDevenshire" wrote: Hi Amanda, There is no equivalent thing in the chart area for conditional formatting, however, with a little work you can create a chart that duplicates what you want. But before I try to ddo that - exactly what do you want - do you want the entire column to change color after they reach some target or do you want the amount above the target to show as a different color than the amount below the target? -- Thanks, Shane Devenshire "Amanda" wrote: I have a worksheet that evaluates the % of a goal. I have it set up as a chart and autoshape (to look like a thermometer). Currently, I have one cell that changes colors based on the comparison between their goal and where they are at....this is the information that fills the chart....however I can't figure out how to change the chart color like the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
can I use conditional format on an auto shape | Excel Discussion (Misc queries) | |||
Excel should allow auto shape boxes to be fixed to points on the g | Excel Discussion (Misc queries) | |||
Auto Shape Menu | Excel Discussion (Misc queries) | |||
column to column conditional formatting won't work, need formula | Excel Worksheet Functions |