Home Tags Excel

Tag: Excel

Find Unique Countries Visited List

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...
Copy Excel Chart on Same Worksheet

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...
AverageIF Across Excel Worksheet Tabs AverageIF Function Result

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

Sum Across Excel Worksheets Tabs

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...
Better Format for Excel Chart Secondary Axis Columns Overlap with 3 Series

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



Excel Overlapping Columns on Second Axis for 3 Series

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...
Excel Overlapping Columns Chart Secondary Axis

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

Calculating Hours Difference of Time in Excel Spreadsheets

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...
Excel Array Solution

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

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link