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...

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...
Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find...

How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)

So I saw this chart in an Excel forum and a user was asking this: “chart - not sure about this one I've created a...
Overlapped Horizontal Categories

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...

Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial

In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...

How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)

In are recent post, I showed you how to create a Bullet Chart in Excel.  Pete, then sent me another way to create a...
Copy an Excel Chart on Same Worksheet Keeps Same Data Reference Final Copied Charts

How-to Copy a Chart and Change the Data Series Range References

Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

How-to Make an Excel Stacked Area Chart Cliff

A while back, I published an article on how to make an Area Cliff Chart. Now this isn’t a standard chart type. If you use the Standard...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!