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?

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

    Colour negative border differently

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

    How do you invert legend data?

    rainbowraven, Jun 8, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    79
    Andy Pope
    Jun 8, 2006
  3. Alison
    Replies:
    1
    Views:
    112
  4. Luci
    Replies:
    1
    Views:
    161
    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:
    122
    Jon Peltier
    Jan 2, 2008
  6. Feejo

    How to invert 2 series?

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