How do I get my Pivot Charts to not reset to automatic colors?

%3CLINGO-SUB%20id%3D%22lingo-sub-2552645%22%20slang%3D%22en-US%22%3EHow%20do%20I%20get%20my%20Pivot%20Charts%20to%20not%20reset%20to%20automatic%20colors%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552645%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20creating%20some%20dashboards%20in%20Excel%20that%20are%20mainly%20focused%20on%20the%20performance%20of%20our%20business%20partners.%20The%20file%20is%20too%20large%20to%20attach%2C%20but%20I%20will%20include%20a%20few%20screenshots%20for%20reference.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22constrictor_0-1626357732480.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296125i6AC701AD7EBF2BB5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22constrictor_0-1626357732480.png%22%20alt%3D%22constrictor_0-1626357732480.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22constrictor_1-1626357763684.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296126iADD418C17D349E8E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22constrictor_1-1626357763684.png%22%20alt%3D%22constrictor_1-1626357763684.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22constrictor_2-1626357820885.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296127i8D031C123B8B9920%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22constrictor_2-1626357820885.png%22%20alt%3D%22constrictor_2-1626357820885.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESince%20this%20data%20is%20from%20large%20data%20queries%2C%20I%20have%20used%20Pivot%20Tables%2FCharts%20and%20Slicers%20for%20analysis%20and%20accessibility.%20It%20is%20important%20that%20each%20outside%20processor%20has%20a%20unique%20color%2C%20and%20all%20of%20the%20Pivot%20Charts%20work%20fine%20when%20no%20slicers%20are%20used.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20most%20of%20the%20charts%2C%20when%20I%20use%20a%20slicer%2C%20it%20maintains%20the%20intended%20color%2C%20because%20I%20have%20gone%20through%20every%20chart%20and%20made%20sure%20that%20under%20Format%20Data%20Series%20-%26gt%3B%20Series%20Options%2C%20the%20Line%20is%20set%20to%20a%20specific%20%22Solid%22%20color%2C%20not%20an%20automatic%20color.%20The%20intended%20result%20is%20seen%20below%2C%20on%20the%20Delivery%20Dashboard%20for%20Tier%201%20processors%2C%20where%20ISP%20is%20represented%20in%20gold.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22constrictor_3-1626358167876.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296128i0C3D115CE345C988%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22constrictor_3-1626358167876.png%22%20alt%3D%22constrictor_3-1626358167876.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20for%20a%20few%20of%20the%20charts%2C%20when%20I%20use%20a%20slicer%20the%20Line%20color%20resets%20to%20automatic%2C%20and%20has%20the%20default%20blue%2C%20as%20shown%20below%20on%20the%20ReWork%20Dashboard.%20Here%2C%20ISP%20is%20Gold%20on%20one%20chart%20and%20default%20blue%20on%20another.%20When%20I%20unfilter%20the%20slicer%2C%20all%20of%20the%20original%20members%20have%20been%20set%20back%20to%20automatic.%20The%20same%20happens%20for%20Tier%202%20Processors.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22constrictor_5-1626358588568.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296133iAAF5329AF27CFD6C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22constrictor_5-1626358588568.png%22%20alt%3D%22constrictor_5-1626358588568.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20using%20the%20advice%20listed%20%3CA%20title%3D%22Reference%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-can-i-stop-excel-from-changing-the-colors-of-my-chart%2Fm-p%2F80475%22%20target%3D%22_blank%22%3Ehere%3C%2FA%3E%26nbsp%3Bby%20user%20mbiscotto.%20However%2C%20that%20didn't%20change%20anything.%20Additionally%2C%20my%20first%20attempt%20at%20making%20this%20document%20did%20not%20utilize%20queries%20for%20downloading%20data%2C%20but%20this%20one%20did.%20The%20first%20time%20around%2C%20all%20the%20charts%20worked%20perfectly%2C%20this%20time%20there%20are%20about%205%20problematic%20charts.%20I%20have%20tried%20disconnecting%20and%20reconnecting%20slicers%2C%20restarting%20the%20app%2C%20but%20nothing%20has%20worked.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20on%20Excel%20for%20Windows%202008%2C%2032-bit%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2552645%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I have been creating some dashboards in Excel that are mainly focused on the performance of our business partners. The file is too large to attach, but I will include a few screenshots for reference. 

constrictor_0-1626357732480.png

constrictor_1-1626357763684.png

constrictor_2-1626357820885.png

Since this data is from large data queries, I have used Pivot Tables/Charts and Slicers for analysis and accessibility. It is important that each outside processor has a unique color, and all of the Pivot Charts work fine when no slicers are used. 

 

For most of the charts, when I use a slicer, it maintains the intended color, because I have gone through every chart and made sure that under Format Data Series -> Series Options, the Line is set to a specific "Solid" color, not an automatic color. The intended result is seen below, on the Delivery Dashboard for Tier 1 processors, where ISP is represented in gold.

constrictor_3-1626358167876.png

 

However, for a few of the charts, when I use a slicer the Line color resets to automatic, and has the default blue, as shown below on the ReWork Dashboard. Here, ISP is Gold on one chart and default blue on another. When I unfilter the slicer, all of the original members have been set back to automatic. The same happens for Tier 2 Processors.

constrictor_5-1626358588568.png

 

I tried using the advice listed here by user mbiscotto. However, that didn't change anything. Additionally, my first attempt at making this document did not utilize queries for downloading data, but this one did. The first time around, all the charts worked perfectly, this time there are about 5 problematic charts. I have tried disconnecting and reconnecting slicers, restarting the app, but nothing has worked. 

 

I am on Excel for Windows 2008, 32-bit

 

 

0 Replies