Final Pivot Table Data Format

How-to Convert an Existing Excel Data Set to a Pivot Table Format

In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...

How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis

In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question - How...

How-to Create Modify and Delete an Excel Pivot Table Calculated Field

I am sure you have created a Pivot Table in your Excel Workbook.  However, have you wanted to easily learn how to add a...

How-to Create a Combo Line and Column Pivot Chart

Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts.  I recently saw a post asking for this help: "Please...

How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values

I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...



How-to Create a Dynamic Excel Pivot Table Dashboard Chart

In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart And then I...

How-to Insert Slicers into an Excel Pivot Table

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...

Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...

A fan of the blog asked a question about this post: Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...

Class Exam Grade Excel Chart Using Slicers and a Pivot Table

Here is Don’s amazing reply to the recent Friday challenge.In this example, Don has elevated his Excel Slicer Pivot Charting to a whole new...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link