| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Colour negative border differently
Does anyone know if there's a way to colour the negative borders in a bar
chart differently if they are negative (otther than cycling through each point individually and colouring them). One can use 'invert if negative' with a fill but in a bar chart with a lot of points you only see the border. Kind regards, Mark |
|
#2
|
|||
|
|||
|
Hi,
Have a look at Jon's example of conditional charts. You can format the columns interior and border. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Mark Stephens wrote: Does anyone know if there's a way to colour the negative borders in a bar chart differently if they are negative (otther than cycling through each point individually and colouring them). One can use 'invert if negative' with a fill but in a bar chart with a lot of points you only see the border. Kind regards, Mark -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Blink a cell in Excel if negative or red colour | Excel Discussion (Misc queries) | |||
| Border misaligned | New Users to Excel | |||
| Problems with Colour Printing | Excel Discussion (Misc queries) | |||
| Display negative data points differently. | Charts and Charting in Excel | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Linear Mode
