Chart
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
This quick tutorial will show you how-to copy an Excel Chart on Same Worksheet such that it uses a new data reference instead of the original reference.
EXPLORE THE LIBRARY
Tag: How-to
Averageif
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
A quick tutorial that teaches how to create an AverageIF Formula that will exclude Zero (0) and blank values when averaging across many Excel Worksheet Tabs
Chart
How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts
Learn how to highlight horizontal axis category labels in an Excel Line Chart. Click here to see how simple this technique can work for your graphs.
Array
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria. Three posts ago, you received a challenge
Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
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
Char
How-to Add a Hard Return to an Excel Concatenate Formula
Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function. But how do you add other controls like a Hard Return or a Tab to your Concatena
Chart
How-to Group and Categorize Excel Chart Legend Entries
If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed that it was not clear on my Stacked Column Chart which ser
File Download
How-to Unprotect an Excel Worksheet If You Forgot the Passcode
Several years ago, I created an Excel workbook and I “Protected” a worksheet, but, I forgot the passcode the next day. Try and try, I couldn’t remember the password. Therefore, I could nev
Challenge
How-to Visualize 17000 Data Points of Upload and Download Times
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what i