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...
Titanic Mortality Dashboard
Today marks the 100th anniversary of the tragic sinking of the RMS Titanic. On that fateful day, over 1,500 people died when the Titanic...
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...
How-to Highlight or Color Rings in an Excel Radar Chart
Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an...
How-to Recreate a NYT InfoGraphic Mustache Grouping Chart in Excel
I love trying to create an Excel chart that was originally drawn with an Infographic software package. Back in 2011 I saw a New York...
Olympic Medal Count Dashboard
So the summer Olympics start this week. So I thought it would be a good time to visit how one might create an Olympic...
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data.
Read it over, but really, the last line of the...
2008-2012 Summer Olympics Medal Count Dashboard Part 2
Wow, what a Summer Olympics. the 2012 medal count is so close. China and the USA are neck and neck in terms of total...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Sales executives are always pushing their sales teams. They typically do this by setting sales quota’s for their salespeople. Quotas are thresholds or minimum...
