+ Reply to Thread
Results 1 to 3 of 3

Pivot chart colour formatting reverts back to inverse white

  1. #1
    Registered User
    Join Date
    07-30-2017
    Location
    Bridgend
    MS-Off Ver
    2013
    Posts
    2

    Pivot chart colour formatting reverts back to inverse white

    This is driving me insane. I have a clustered bar chart and I need to make the bars green for the negative values. But every time I close and reopen the spreadsheet the inverse colour reverts back to white. There are slicers in my spreadsheet but none connected to this particular pivot table & chart and it does not have any filters either.

    I'm using Excel 2013, I've had to colour each bar manually for now but I need a permanent solution.

    Any suggestions appreciated.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,969

    Re: Pivot chart colour formatting reverts back to inverse white

    A little difficult to diagnose the issue without sight of the file.
    Perhaps you could attach a sanitized version for us to see?

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Should be straightforward from there.

    BSB

  3. #3
    Registered User
    Join Date
    07-30-2017
    Location
    Bridgend
    MS-Off Ver
    2013
    Posts
    2

    Re: Pivot chart colour formatting reverts back to inverse white

    Screenshot.png

    I've tried to attach a screenshot, axis and title removed but you get the idea - the white bars are supposed to be green.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. tab reverts back to file
    By ketanco in forum Excel General
    Replies: 10
    Last Post: 09-12-2018, 04:02 PM
  2. Macro that reverts template back to original state
    By JamieBlanco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-10-2015, 05:24 PM
  3. Excel Add-In path reverts back to network drive
    By beach_bum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2013, 11:42 AM
  4. Replies: 11
    Last Post: 07-06-2012, 09:08 AM
  5. [SOLVED] In Excel, colour formatting (text and background) reverts to blk
    By malcolm in forum Excel General
    Replies: 1
    Last Post: 07-12-2006, 03:20 PM
  6. Replies: 0
    Last Post: 02-28-2006, 10:20 AM
  7. How do I change the inverse colour in an Excel chart?
    By david_hutton.NO_SPAM in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-21-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1