How-to Copy a Chart and Change the Data Series Range References
Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List
Before we begin, I am going to show...
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 Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
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
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
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...
Calculating Hours Difference of Time in Excel Spreadsheets
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
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...