Normalizing a Time Series Chart

Normalize the data in your Time Series chart to compare the relative differences in percentage over time rather than seeing the absolute value of the measure.

Context

In your Time Series chart, you can show the absolute value of a measure for any given data point, or you can show the relative percentage difference over time.

The relative difference is calculated from the first visible data point to all other visible data points. When the time frame is adjusted (moved, shrunk, or stretched), the relative differences are updated.

Procedure

  1. Set up your Time Series chart.
  2. From the chart action menu, select (Show as percentage) .

Results

The left-hand data point is displayed as 0%, and all values to the right show the relative difference from that point.