by contextures.com
It’s November, a month when we expect cooler temperatures here in Canada. However, it was more like summer last weekend, and we enjoyed an afternoon beverage on the patio. Was that normal? What were the November temperatures over the past few years? Let’s use a pivot table with conditional formatting, to find out!
Continue reading “Conditional Formatting Excel Pivot Table Color Scale”
Excel automatically adds grand totals to a pivot table, if there are multiple items in the row area, or in the column area. See how you can change the automatic grand total headings (sometimes), and quickly remove grand totals if you don’t need them.
After you create a pivot table in Excel, you can filter the data, to focus on specific things. Maybe you want a top product report, or a regional summary, or see the sales to a couple of new customers. You can also use filters on date fields, and there are 3 different types you can use.
Continue reading “Pivot Table Date Field Filters – 3 Types to Try”
Quickly check your sales results over time, or by top products, with the % Running Total feature in an Excel pivot table. This feature is available in Excel 2010, and later versions.
Continue reading “Check Sales Progress with Percent Running Total in Excel Pivot Table”
Excel doesn’t have a Cluster Stack chart type, but you can make a pivot chart with stacked columns that are grouped into “clusters”. See the steps in the video below, and get the sample Excel file, to try it for yourself. Continue reading “Easy Steps for Excel Clustered Stacked Pivot Chart”
When you set up a pivot table, and put fields into the Rows Area or Columns area, Excel groups the items, and calculates the totals for each group. For example, see count of products for each Unit Price. Each item should only be listed once in the pivot table, but sometimes you might see duplicates.
Continue reading “Duplicate Numbers in Pivot Table Items Problem”
With a large pivot table, running a macro that refreshes that pivot table might be painfully slow. The usual macro steps, like turning off screen updating, and disabling events, don’t solve this problem. Try adding an extra bit of code to your macro, to see if that makes the refresh go faster.
Continue reading “Faster Pivot Table Refresh in Excel Macros”
You can use conditional formatting in an Excel pivot table, to highlight specific data, such as months with high sales numbers. This example uses conditional formatting to highlight the pivot table values that are connected to weekend dates. Continue reading “Pivot Table Highlight Weekend Data Conditional Formatting”
Do you create weekly or monthly reports based on pivot tables, and share those reports with clients or co-workers? If there are multiple pivot tables in your report, use this Excel dashboard technique to check all the filters, before you hit Send!
Continue reading “Excel Dashboard Check Pivot Table Filters Before Printing”
If you’re building a formula, and you click on a pivot table value, Excel puts a GetPivotData function into your formula. Here’s how to stop that from happening.
Continue reading “Annoying Pivot Table Problem GetPivotData Formula Fix”
