Comparison values are a great way to make a key values more meaningful—and they are easy to add.

First, you must first have a key value. (See our add a key value article if you haven't done this before.)

Expand the Key Value header, then click on the drop-down arrow to expand the value itself.

Next, click the Add Comparison Value button.

Select the cell that you want to be the comparison value.

The comparison value will appear next to your key value as a percentage with an up or down arrow. The percentage indicates what how much the key value has increased or decreased in comparison to the comparison value.

Questions? Email us at or chat in on the site.

Did this answer your question?