Can't format 'invert if negative' colour programmitically (macroignores it!)

M

Mark Stephens

I have a chart I want to format and I can set the invert if negative property no problem but unlike another chart I have on the same sheet, it will nto remember the negative colour. As per the subject heading I recorded a macro and coloured the negative part of the chart as desired but it did not show up when I opened the macro to find out how to access it, anyone have anyideas how to do it?

M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing color of negative bar when using Invert if negative 9
change the colour of the "invert if negative" option in Excel 1
Display Negative Time Values on Y-Axis 0
Convert Error Bars to Series and Colour 1
Positioning x axis at bottom of chart with negative values 5
How do I plot negative bars/numbers BELOW the main axis in Excel 1
negative currency abbreviated format 1
Changing colours in chart 2

Top