| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Bars that reaches a value turns into a specific color?
How can i make so the bars that reaches a value in the chart to turn into a
specific color and those which doesn't reach the value turns into another? The type of chart i'm using is "Clustered Column" and in the chart there is also a line type chart which is indicating where the goal is reached (it's just a goal line, i don't think you need to bother this part of the chart). I'm using excel 2002 sp3. Any help is highly appreciated! |
|
#2
|
|||
|
|||
|
Hi,
See Jon's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy boho wrote: How can i make so the bars that reaches a value in the chart to turn into a specific color and those which doesn't reach the value turns into another? The type of chart i'm using is "Clustered Column" and in the chart there is also a line type chart which is indicating where the goal is reached (it's just a goal line, i don't think you need to bother this part of the chart). I'm using excel 2002 sp3. Any help is highly appreciated! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple combination bars chart | Charts and Charting in Excel | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
| How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
