How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
Halloween Special – Spider Web, Spider and the Fly Chart
In honor of Halloween I thought I would post something fun. For those that are not in the USA, Halloween is where children dress...
How-to Make a Company Goal Chart or IPAD Battery Chart in Excel
I was looking at my IPod Touch and I really liked the battery graphic that is shown. Then I looked at my IPhone and...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
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...
Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
