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 data set.  Perhaps it was for the month of April...

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 an AverageIF Formula Excluding Zeros Across Worksheet Tabs. Here is the...

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 but I never seen this in all my years of...

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 created that solved the problem that Whitney was having, however,...

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 thought I would answer here.  Here is the question: “This is...

Why is Excel Overlapping Columns When I Move them to the Secondary Axis?

4
Why is Excel Overlapping Columns in this chart? Why EXCEL, WHY are you doing this???  I don’t understand. Have you ever asked yourself this question when Excel overlaps the columns you just moved a...

Calculating Hours Difference of Time in Excel Spreadsheets

6
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you an error, but it doesn't look like an error.  Excel...

Data Transformation – Excel Array Solution

0
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although I was able to compete the challenge, that wasn't good...

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

9
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 months (out of 22) listed in my X Axis. I...

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 Transformation Now it is a tricky challenge because the data is...