Home Tags Excel

# Tag: Excel

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

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

### How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...

### How-to Make a Sales Pipeline Funnel Excel Chart Template

Want to Receive the Next Post?