How-to Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
How-to Use Data Labels from a Range in an Excel Chart
Excel 2013 has some cool features. If you were not aware, here is an awesome Chart Data Label option that you now have when...
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...
Friday Challenge Answers – Food Donation Excel Dashboard Chart
Last week we presented a chart challenge to see how you represent Food Donation data.
Don said that we should keep it simple and sent...
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...
Top Movies – Excel Dashboard – Brian’s Friday Challenge Entry
This was our final entry in the most recent Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
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...
Excel Goal Chart Filling a Bottle of Soda
In a previous post, and one of my favorites, I showed you a unique company goal chart using a beer mug instead of a...
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...
