Home Tags Video Demonstration

Tag: Video Demonstration

Fix Error Current Sales Greater than Sales Goal - Thermometer Chart in Excel

How-to Fix Sales Goal Error of Excel Thermometer Chart

How-to Fix Sales Goal Error of Excel Thermometer Chart I have to admit that I messed up and presented a broken solution for the Excel...
Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request...
Free Excel Dashboard Webinar
Select Large Range Contiguous

Alternate Ways to Select Large and Non-Contiguous Ranges in Excel

Selecting Ranges in Excel Have you ever had an issue using your mouse to select a large set of data in your Excel spreadsheet?  Have...

Excel Overlapping Columns on Second Axis for 3 Series

Stop Excel Overlapping Columns on Second Axis for 3 Series

We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...
Friday Challenge - Find Unique Class List in Excel ANSWER

Friday Challenge – Find Unique Class List in Excel ANSWER

On Friday, I posted this challenge: https://www.exceldashboardtemplates.com/friday-challenge-find-unique-list-in-excel/ You can download the sample data set here:  Challenge Sample Data Check out the post and download / try it yourself before you...



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

How-to Find a Wild Card or Question Mark or Asterisk or Tilde in Excel

Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...

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

How-to Make a Music Festival Schedule Using Excel Conditional Formatting

Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts. However, he originally created the...



How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link