Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table.

It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at one glance.

DOWNLOAD WORKBOOK

ColorScales

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Add Columns to Pivot Table Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout. Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate column...
Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread! They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table. There are several ways that you can filter an Exce...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count. Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...
GETPIVOTDATA Function What does it do? A formula that extracts data stored in a Pivot Table Formula breakdown: =GETPIVOTDATA(data_field, pivot_table, , ,...) What it means: =GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...)   T...