How-to Make a Wall Street Journal (WSJ) Double Lollipop Chart in Excel
In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).
Here is what our final chart...
How-to Add Lines in an Excel Clustered Stacked Column Chart
I have posted several Excel chart samples related to Clustered Stacked Column Charts.
In case you missed them, you can check them out here: Excel...
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help:
"Please...
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 Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
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...
Presenting Metrics Data – How would you create a chart for this data?
In my last post I asked how you would create a chart for this request:
Presenting Metrics Data
Trying to find the best way to...
How-to Split Up Email Address Text with Excel Formulas – Part 2
In my previous Friday Challenge, Tracey wanted to know how to split up email address text in Excel. The sample text that Tracey wanted...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
Find And Replace from a List of Multiple Emails in Excel without VBA
Find And Replace from a List of Multiple Emails in Excel without VBA
I had a recent request from a friend who needed to Find...
