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 Create an Excel Dashboard Column Chart with 2 Axis Groupings
Recently I saw this in the MrExcel Forums. The title “Weird Charts with 3 Axis” intrigued me.
I determined that they were looking to put...
New Take on the Excel Project Status Spectrum Chart
Leonid, a wonderful reader of our website, sent in a new take on my Excel Project Status Spectrum Chart. Here is what his looks...
Friday Challenge Answer – Dynamic Excel Chart Using Checkboxes for Multi Year by Month...
A big shout out to Pete who submitted this answer to my last Friday Challenge.
You can check out the challenge here:
Friday-challenge-excel-mutli-year-graph-by-month
Check out the video...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
Friday Challenge – Recreate an Excel Project Status Spectrum Chart
I am always looking for charts or anything that I can put into an Excel chart. In fact, I just skim the Wall Street...
Removing Gaps in an Excel Clustered Column or Bar Chart (Part 2)
Removing Gaps - Excel Clustered Column or Bar Chart (Part 2)
In an earlier Friday Challenge, I posted a problem where someone wanted to remove...
Excel Clustered Column Chart Conundrum
Many, many, many Excel users post this problem in user forums. And this one always throws me for a loop and takes me time...
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
The...
