Home Tags How-to

# Tag: How-to

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

Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...

### How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

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

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

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

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

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

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

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

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

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

### How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...

### How-to Make a Sales Pipeline Funnel Excel Chart Template

Want to Receive the Next Post?