Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use conditional formatting in charts (bar, line, timeline) to highlight individual bars, ranges, scatters, or bubbles.

How to use condition cell formatting in tables and Gantt chart, read Conditional cell formatting.

Overview

Conditional formatting is available in bar, line, and timeline [1] charts for types: bar, scatter, range, and bubble [2].  

...

Select Conditional formatting [3] for the measure if its type is bar, scatter, range, or bubble

...

Specify one or several rules [4] to detect charts that should have different colors. You can set one or multiple rules, the first matching rule will be used. If no rule is applied, then the default color is used for the chart [5].

There are two ways how to apply those rules [7]: you can set them on the values displayed in the charts or on the value calculated by a custom formula.  Also, there are several ways to define conditions [6]: Range, Exact value, Regular expression, and Top/Bottom. Select one of them. 

...