﻿ How-To Archives - Page 2 of 16 - Excel Dashboard Templates
Home How-To Page 2

# How-To

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

14
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

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 Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

1
Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...

### A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series

1
Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart we...

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

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

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

### Friday Challenge – Data Transformation Solution

0
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...

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

### Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT

0
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...

### Advanced Excel Summation Techniques Using Pivot Table

0
There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...
Want to Receive the Next Post?