Enable Middle Color to add an optional middle color point to fill conditional formatting.
Middle Color
Select the color used for the middle point of the configured range.
Middle Color Opacity
Adjust the transparency of the middle color.
Middle Color Origin
Select how the middle threshold value is determined.
- This Series – calculate the threshold using values from the selected series.
- Constant Value – specify a fixed threshold value.
- Another Series – calculate the threshold using values from another series.
Middle Color Function
Select the function used when Middle Color Origin is set to This Series.
- Above Min – use a value above the series minimum.
- Average (default) – use the average series value.
- Percentile – use a specified percentile of the series values.
The middle-color settings are available only when Middle Color is enabled. Additional controls depend on the selected origin and function.
Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?