PivotChart Conditional Formatting 3-Colour Range Not Working with Limited Selections

[trikky]

I have some cells on a pivotchart where I've done conditional formatting with a 3-Colour scale. When there is all my data, it seems to show fine. However, when I've filtered down the results to a smaller sample size (in the example below, three lines), the colouring is nowhere near correct.

Formatting rules are as follows:
3-Colour Scale
Min - Type Percent, Value 0, Colour Red
Mid - Type Percent, Value 50, Colour Yellow
Max - Type Percent, Value 100, Colour Green

Formatting rule - All cells showing "Column Name" values for "Row Name". I've tried changing it to be All cells showing "Column Name" values and it made no difference
Each column has a separate rule as they are separate statistics. Each row is a person to whom the stats apply.

There are no other rules applied, and I have confirmed it's percent, not percentile (which I suspected was causing this issue initially).

Because the cell colouring doesn't appear in the post and I can't post an inline image, The font colours in my sample table indicate the cell colours. As you can see, it's not quite right. Even the same number (50%) is coloured differently.

[TABLE="width: 880"]
<tbody>[TR]
[TD="class: xl82, width: 117"]41.7%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"][/TD]
[TD="class: xl83, width: 117"]50%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[/TR]
[TR]
[TD="class: xl82"]53.4%
[/TD]
[TD="class: xl83"]0%
[/TD]
[TD="class: xl83"]38%
[/TD]
[TD="class: xl83"]86%
[/TD]
[TD="class: xl83"]33%
[/TD]
[TD="class: xl83"]100%
[/TD]
[TD="class: xl83"]71%
[/TD]
[TD="class: xl83"]25%
[/TD]
[TD="class: xl83"]73%
[/TD]
[TD="class: xl83"]0%
[/TD]
[/TR]
[TR]
[TD="class: xl82"]36.1%
[/TD]
[TD="class: xl83"]0%
[/TD]
[TD="class: xl83"]33%
[/TD]
[TD="class: xl83"]0%
[/TD]
[TD="class: xl83"]100%
[/TD]
[TD="class: xl83"]100%
[/TD]
[TD="class: xl83"]100%
[/TD]
[TD="class: xl83"]67%
[/TD]
[TD="class: xl83"]0%
[/TD]
[TD="class: xl83"]50%
[/TD]
[/TR]
</tbody>[/TABLE]


Interestingly enough, if I filter it down further to one person (line 1 of the example above), this is how it turns out...everything green.

[TABLE="width: 880"]
<tbody>[TR]
[TD="class: xl82, width: 117"]41.7%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"][/TD]
[TD="class: xl83, width: 117"]50%
[/TD]
[TD="class: xl83, width: 117"]100%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[TD="class: xl83, width: 117"]0%
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much for your assistance.

 

[Worf]

Re: Help Required: PivotChart Conditional Formatting 3-Colour Range Not Working with Limited Selections

Are you working with a pivot table and pivot chart or just a pivot table?

You can upload images or workbooks to a hosting site and paste a link here.

 

[trikky]

Re: Help Required: PivotChart Conditional Formatting 3-Colour Range Not Working with Limited Selections

Are you working with a pivot table and pivot chart or just a pivot table?

Sorry, yes...it's a pivotable. I was also working with pivot charts elsewhere so they were on my mind.

You can upload images or workbooks to a hosting site and paste a link here.

Yup...know that, but sometimes there are limitations on what such sites one can use from certain networks (such as work networks) so using the hosting sites isn't always an option.

I've since updated all the rules to number and they seem to be working more appropriately now.