Challenge
Friday Challenge – My Answer – Chart This Data in Excel
Check out How I Used Different Graphing Techniquest to Chart This Data in Excel, including Pivot Tables, Slicers and Multi-Level Labels.
EXPLORE THE LIBRARY
Tag: Pivot Chart
Calculated Item
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 can you do this same type of Pivot Chart but
Chart
How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart
Today I answer a viewer question. “How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?” Well there are a few tips and tricks to create this t
Chart
3 Ways to Add a Target Line to an Excel Pivot Chart
Check out this post to LEARN 3 Different Ways That you Can Add a Target Line / Goal Line to Microsoft Excel Pivot Chart for you Executive Dashboard.
Chart
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 advise if it is possible to combine a pivot line graph a
Chart
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
Chart
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis
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
Challenge
Class Exam Grade Excel Chart Using Slicers and a Pivot Table
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.