Group Column Chart with Lines for Excel Dashboard Presentations
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...
Using the Camera Tool to Create a Vertical Line Chart in Excel
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...
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...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
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...
Why is Excel Overlapping Columns When I Move them to the Secondary Axis?
Why is Excel Overlapping Columns in this chart? Why EXCEL, WHY are you doing this??? I don’t understand. Have you ever asked yourself this...
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked...
Last week I posted a Friday Excel Challenge!. Fun times. How did you do? Spoiler alert, if you don’t know how to create this...
Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart
Here is a late entry :) Thanks Leonid. This is an Awesome response!
Leonid was responding to this recent challenge: Friday Challenge – Pipeline Usage...
Quickest Way to Select and Align Charts for an Excel Dashboard
Select and Align Charts for an Excel Dashboard
Creating dashboards can take a lot of time. With this simple technique that I just learned, you...
