| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Inverse colors in bar chart
Hi,
I have a bar chart with series positive and negative. I'm looking for solution that would change color of the bar chart for points where value is negative (or if it meet a condition - like <5). Any suggestions? I would also need to control color of the positive/negative bars. Many thanks, Marcin |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Inverse colors in bar chart
Hi,
For information on the use of Invert if negative see, http://www.andypope.info/charts/Invertneg.htm And for conditional charts see, http://peltiertech.com/Excel/Charts/ChartIndex.html#C Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Marcin Peciak" wrote in message ... Hi, I have a bar chart with series positive and negative. I'm looking for solution that would change color of the bar chart for points where value is negative (or if it meet a condition - like <5). Any suggestions? I would also need to control color of the positive/negative bars. Many thanks, Marcin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar Chart colors less than zero | Excel Discussion (Misc queries) | |||
| How do I show inverse data in a chart? | Charts and Charting in Excel | |||
| Line chart colors | Charts and Charting in Excel | |||
| static colors in chart chart | Charts and Charting in Excel | |||
| How do I change the inverse colour in an Excel chart? | Charts and Charting in Excel | |||
Linear Mode
