| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
auto format chart colours
Is it possible to have a bar chart where all values
greater than 100 are automatically coloured red, less than 100 are coloured green? thanks |
|
#2
|
|||
|
|||
|
Yes, have a look at Jon's examples of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy bobf wrote: Is it possible to have a bar chart where all values greater than 100 are automatically coloured red, less than 100 are coloured green? thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| Chart Format & Linking? | Charts and Charting in Excel | |||
| Change the default chart colours | Charts and Charting in Excel | |||
| pivot chart format | Charts and Charting in Excel | |||
| exporting a chart to gif format using COM (Excel v11 and .net) | Charts and Charting in Excel | |||
Linear Mode
