Knowledge Base
Zebra BI for Excel

Conditional Variance with Neutral Color

Applies to:
Zebra BI Charts for Excel
Zebra BI Charts for PowerPoint

The Conditional Variance with Neutral Color feature lets you define a tolerance range where variances are shown in a neutral color instead of positive (green) or negative (red).

This helps you reduce noise and focus attention on meaningful deviations.

Introduction

In many scenarios, small differences are expected and shouldn’t stand out.

With a neutral zone, you can:

  • Highlight only material variances
  • Reflect real business thresholds
  • Make reports clearer and easier to interpret

Configuration

Zebra BI Charts

  1. Hover over the legend segment on the left side of the visual
  2. Click inside the blue rectangle
  3. Set Lower and Upper thresholds
  4. Choose a Neutral variance color

Values within the thresholds will appear neutral; those outside the thresholds will retain positive/negative colors.

Common use cases

Directional (red → neutral → green)

Use when direction matters (e.g., Revenue vs Plan):

  • Small differences (e.g., ±15%) → neutral
  • Larger drops → negative
  • Larger gains → positive

Understanding thresholds

  • You can use % or absolute values
  • The neutral zone is defined by lower and upper limits
  • Lower threshold must be ≤ upper threshold

Default behavior

By default, thresholds are set to ±0%, meaning the feature is turned off.

What gets colored

Charts

– the relative variance chart
– the absolute variance chart
– indicators of variances in the comment box

⚠️The configured conditional variance settings in Charts apply to all variances included.

Summary

Use Conditional Variance with Neutral Color to define what “acceptable” means in your business and keep focus on what truly matters.