Show Change As A Delta Symbol in Excel

changing "change" to deltas in Excel

When I’m working with tables or charts, I like to make labels as short as possible. So when I’m showing a change in a metric over time, like percent difference, I’ll use the delta symbol (Δ) instead of writing out “change” or “difference.”

To do this, just type a capital D (I think of d for delta), select it, then change the font to Symbol. Voila! You have a delta character.

Note: If you’re using a formatted table — and you should almost always format your data as a table — the delta may mess up your heading formatting. In the example below, it made the white font black. If it does, nbd … Just reformat it to match.

I use this when I’m formatting the Search Queries report in Google Webmaster Tools (under Traffic). Here’s what it looks like before and after:

showing delta in excel
Click for larger image.

Photo by lbj79us.

Learn More

You can learn more about data formatting in my Annielytics Dashboard Course, a 16-hour video course that will teach you how to put your data in stilettos and work the pole. :)

Leave a Reply

Your email address will not be published. Required fields are marked *