Chart
How-to Fix Sales Goal Error of Excel Thermometer Chart
Learn how to fix a problem with my Thermometer template that was created in the original version of the Excel chart when the Sales is greater than the goal.
EXPLORE THE LIBRARY
Tag: Video Demonstration
Axis Labels
Replace Numbers with Text in Excel Radar Chart Axis Values
Checkout this Trick to Fake Excel Radar Chart Axis Values with Text instead of Numbers. Click now to get all the Best Excel Tips Now.
How-To
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Learn how to use alternate techniques to select very large ranges in Excel and also another way to select non-contiguous ranges.
Chart
Stop Excel Overlapping Columns on Second Axis for 3 Series
If you have 3 series in an Excel Column Chart and move one to the Secondary Axis, learn the trick on how to Stop Excel Overlapping Columns on Secondary Axis
Challenge
Friday Challenge – Find Unique Class List in Excel ANSWER
On Friday, I posted this challenge: 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 you
Chart
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 I mean: Overlapped Horizontal Categories If you r
How-To
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 or Tilde’s. If you are trying to Find or Find & Replac
Area Chart
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 Excel Area Chart with blank data, Excel will interpolat
Conditional Chart
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 schedule in the worksheet area using ce
Chart
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 a chart”. Here is the basis of the question at hand: “I’m not su