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 


0
mark6917 (19)
8/10/2005 12:15:15 AM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
427 Views

Similar Articles

[PageSpeed] 7

Hi,

Have a look at Jon's example of conditional charts. You can format the 
columns interior and border.
http://peltiertech.com/Excel/Charts/ConditionalChart1.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
0
andy9699 (3616)
8/10/2005 7:44:43 AM
Reply:

Similar Artilces: