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

Discussion in 'Excel Charting' started by Mark Stephens, Apr 23, 2014.

  1. 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.
     
    Mark Stephens, Apr 23, 2014
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mark Stephens

    Colour negative border differently

    Mark Stephens, Aug 10, 2005, in forum: Excel Charting
    Replies:
    1
    Views:
    81
    Andy Pope
    Aug 10, 2005
  2. rainbowraven

    How do you invert legend data?

    rainbowraven, Jun 8, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    73
    Andy Pope
    Jun 8, 2006
  3. Alison
    Replies:
    1
    Views:
    104
  4. Luci
    Replies:
    1
    Views:
    155
    Andy Pope
    May 10, 2007
  5. nathanhutto

    Why does the Y axis invert in charting?

    nathanhutto, Nov 19, 2007, in forum: Excel Charting
    Replies:
    5
    Views:
    115
    Jon Peltier
    Jan 2, 2008
  6. Feejo

    How to invert 2 series?

    Feejo, Dec 31, 2007, in forum: Excel Charting
    Replies:
    1
    Views:
    74
    Jon Peltier
    Jan 1, 2008
  7. Breck
    Replies:
    9
    Views:
    226
    Jon Peltier
    Mar 4, 2008
  8. Tom
    Replies:
    1
    Views:
    165
    Bernard Liengme
    Aug 19, 2009
Loading...