 |
 |
 |
 |
 |
|
|
||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
10-04-2005, 07:05 AM
|
|||
|
|||
|
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
10-04-2005, 08:05 AM
|
|||
|
|||
|
Re: Bars that reaches a value turns into a specific color?
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
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
