In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a database programmer when you create your data layouts. If you miss
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 can you do this same type of Pivot Chart but
I am sure you have created a Pivot Table in your Excel Workbook. However, have you wanted to easily learn how to add a calculated field? It is not too hard, but it is not always intuitive.
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 advise if it is possible to combine a pivot line graph a
I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5 values. The user had to create this pie chart regularly from a larger data set and
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
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,
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 Axis They wanted to know how to do it with a Pivot Chart i
Check out Don's answer to the recent Friday Challenge. Don uses Excel Slicer Pivot Charts to display Grade counts by Class and by Exam.