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

0
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

6
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...
Select Large Range Contiguous

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

0
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

8
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

0
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

2
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

2
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

2
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

4
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

10
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