How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable?
Check out this chart to see what...
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...
Chart Increase at Time Interval in Excel
Here is my answer to the most recent Friday Challenge. Would welcome any comments below on what you think (flaws, likes, thoughts…)
In case you...
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
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...
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge,
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
where a user wanted the following:
Creating a graph of...
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...
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
The...










