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.)

Under the Key Value header click on the drop-down arrow to expand.

Next, click the Add data button under Comparison Value.

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?