Tag: Excel
Friday Challenge – Chart This Data in Excel
Chart This Data in Excel
Today's challenge is a simple one but has many answers. You will be presented with a small set of data and I...
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...
Friday Challenge – Find Unique Values from CSV List
Welcome back to another Friday Challenge at Excel Dashboard Templates!
Today's challenge is pretty straight forward and can be done manually (although it will take...
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...
Why is Excel Overlapping Columns When I Move them to the Secondary Axis?
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...