+ Reply to Thread
Results 1 to 2 of 2

Series Fill Color displaying different color than what is configured

  1. #1
    Registered User
    Join Date
    04-23-2020
    Location
    US
    MS-Off Ver
    2016
    Posts
    2

    Series Fill Color displaying different color than what is configured

    Hello all,

    I have a spreadsheet that has 3 Pivot Tables and associated Pivot Chart that are tied to the same data source. I have several Slicers that are attached to all 3 charts. The charts are Stacked Area charts. Periodically when I refresh the data or use the Slicers the Fill Color of the data series in the charts get 'corrupted'. What I see is that most if not all of the data series in the charts turn blue, even though the configured color in the Format Data Series says the series should be a different color.

    In the image attached I'm trying to show what I see. The highlighted series is set to be an Automatic color and it should be orange (seen on the right), but the series in the chart (which is selected) is blue along with many of the other series. The series are all supposed to be different colors.

    The way I can correct this is to select the series and then toggle the Fill setting between Pattern Fill and Automatic. Doing this somehow "refreshes" something and the color in the chart changes to the correctly configured color.

    I am dumbfounded by this, and it costs a ton of time to correct. Any thoughts or ideas would be greatly appreciated. Is this a possible bug I should report?

    Capture.PNG

    Thanks for any help

  2. #2
    Registered User
    Join Date
    04-23-2020
    Location
    US
    MS-Off Ver
    2016
    Posts
    2

    Re: Series Fill Color displaying different color than what is configured

    I had another instance of this occur. If anyone has every experienced something like this would be great to hear from you. ;-)

+ 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. Delete CF fill color, replace with regular fill color. Short code, can't figure it out!
    By excelfriend1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2016, 09:03 PM
  2. [SOLVED] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  3. Set chart series color to match series legend entries font color
    By Equipoise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 07:33 AM
  4. Replies: 0
    Last Post: 06-07-2012, 11:09 AM
  5. VBA Code to Automate Series of Cell Fill Color
    By Mark21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2011, 08:05 PM
  6. Subtracing fill color cells and displaying them somewhere
    By psxsquall in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2010, 03:55 PM
  7. Series fill color method
    By Jbentley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2009, 01:17 AM

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