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...
Dashboard Chart of Tiger Wood’s Money Ranking List and Golf Earnings
With the upcoming Open Championship (also known as the British Open) in Royal Lytham & St. Annes Golf Club, I wanted to see how...
How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts
The Problem
Recently a fan contacted me and asked how she change the horizontal axis could do the as follows:
"I am trying to bold 5...
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
How-to Make a Dynamic Chart Using Offset Formula
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables. This is a very easy...
How-to Connect Gaps in a Line Chart in Excel
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete. For instance, you may...
Create Dynamic Excel Chart Conditional Labels and Callouts
Chart Conditional Labels and Callouts
Learn how to make the simple and easy these Excel Chart Label Callouts:
In my most recent article, I described how...
Practice Makes Perfect Excel Dashboards and Charts
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...
How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...