Home Tags How-to

Tag: How-to

Copy Excel Chart on Same Worksheet

How-To Copy an Excel Chart on Same Worksheet with a New Data Reference

8
Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...
AverageIF Across Excel Worksheet Tabs AverageIF Function Result

How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

2
I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create...
How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

7
The Problem Recently a fan contacted me and asked how she change the horizontal axis could do the as follows: "I am trying to bold 5...

Excel Array Formulas SumIF

Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria

0
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...
Single Image Tree Goal Chart

How-to Make an Excel Single Image Goal Chart

2
Recently, a healthcare company employee contacted me about a chart he wanted to create.  The company that he works for is trying to save...
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 Add a Hard Return to an Excel Concatenate Formula

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

How-to Group and Categorize Excel Chart Legend Entries

2
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...
Unprotect Worksheet Buttons

How-to Unprotect an Excel Worksheet If You Forgot the Passcode

3
Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day.  Try and try,...
Network Data Usage Excel Chart

How-to Visualize 17000 Data Points of Upload and Download Times

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