# Dashboard Rescue with Excel MVP Michael Alexander

In this episode, Excel TV guest Excel MVP Michael Alexander joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Excel MVP Jordan Goldmeier in discussing the DOās and DONāTās of data visualizationā¦..avoiding the dreaded ice cream sandwich syndrome!

Data visualization can enhance the message you want your metrics to display if you avoid the following crimes against data.Ā  Before plugging in that clip art, consider these questions:

• ## How??? Crimes against data viz.. Can they be stopped?

Take a ride with the Excel crew as they analyze these worst offenders! What didnāt work and what they should have done.

## Example 1. Ā Education Dashboard

In Example 1, the message being presented relates to the level of education of some population in percentages.

Rick:Ā  Scores about a 3. There is no sequential order of sections.Ā  There is no story telling Postgrad is better than High School and College is better than Postgrad.

Jordan:Ā  Itās a bubble chart and the percentage numbers donāt match with the bubbles.Ā  No clear message is being conveyed.

Michael: Lame āice cream sandwichā graphics!Ā  Bad colors and clip art.Ā  Clip art dashboards must be executed well or left out! I agree with Rick that is should have been a simple bar chart ordered sequentially.

Final take away – Infographics can be cool, but make sure the message is clearly conveyed.Ā  And avoid handless people with ice cream sandwiches.Ā

## Example 2. Ā Polls Dashboard

Just in time for election season, Szilvia presents this donut chart for the Excel TV expert panel.

Beyond the donut obsession and the obvious poor use of color, i.e., Red = No and Green = Yes, flip-flopped, the question āDoes this even need a graphic?ā jumps out!

Michael: Too many words!Ā  Iām never going to read this!

Jordan: Does it even need a graphic?Ā  People forget the data is the message and not the art or fun stuff.

Rick: There are actually two questions in the graphic and it is not obvious to which question the data applies.

Final score: 3.

Take away – Data visualization should be instantly obvious.

## Example 3. Ā 3D Pie Charts Dashboard

Szilvia presents pie charts as the most abused graphic and 3D makes it worse!

Michael: 3D is outdated.Ā  It is like 1996 or wearing a white glove to work ala Michael Jackson.

Jordan: Microsoft added 3D pie charts probably just to show capability of their technology and the market share of Windows.

Rick: Minus 10 score for Zach Barresse! Zach said, āDonāt get me started on 3D charts in Excel.ā Enough said.

Take away ā Just because you can do 3D doesnāt mean you should!

## Example 4. Venn Diagrams in a Dashboard

Szilvia highlights how bad this graphic is.

Michael: Read as a Venn diagram, this graphic says that 95% of the people at Thomson Reuterās values donāt include Trust, Partnership, Innovation, or Performance.Ā  Nerds are laughing over this marketing graphic.Ā  The context has to fit to use a Venn diagram.Ā  Venn Diagrams are good for presentations or PowerPoints.

Take away – If you donāt know what a Venn diagram is, donāt use it!

# Moving on to COLOR SCHEMES in Dashboards

## Color scheme specimen 1.

Rick: Proportion filled charts are horrible; blows on ALL levels. Just put it into a pie chart ā and pie charts blow! Ā It looks like Jordan Goldmeier’s Excel maze or Ant Farm!

Szilvia: Looks like Hippie wedding sand art. Bad color and 3D.

Jordan: The axis doesnāt start at 0 and you canāt tell proportions from this graphic. I suggest a line chart for this data.

Michael:Ā  Is this actually a painting or a chart? It is South Parky and looks like layered construction paper. It would be better as a painting on your bankās wall!

Final score – 8 for Corporate Art and a 1 for a dashboard.

## Color scheme specimen 2.Ā  Space Race

Szilvia: Classic example of way too much information on a single page!

Rick: It looks like the Donkey Kong maze and I expect to see Donkey Kong at the top throwing barrels down trying to crush people.

Jordan: Too much irrelevant data on the timeline.

Michael: It looks like the map of the subway system in Washington DC.Ā  Turn it into an infographic.

Final analysis ā send it back to space!

And there you have the results from the Excel TV expert panel with guest host Excel MVP Michael Alexander.

Latest posts by Lesley Davidson (see all)

Tags

#### You may also like

September 12, 2015

## 35: Michael Alexander ā DataPig Technologies ā Power BI Bootcamp

35: Michael Alexander – DataPig Technologies – Power BI Bootcamp

January 19, 2016

## 40: Ginger Grant ā Power BI Blogger, Trainer and Speaker

40: Ginger Grant – Power BI Blogger, Trainer and Speaker

November 14, 2015

## Custom Formats for Dashboards and Spreadsheet Applications

Custom Formats for Dashboards and Spreadsheet Applications

March 12, 2019

## Dashboard Demo: Building your first Power BI Report

Dashboard Demo: Building your first Power BI Report

March 15, 2012

## A Dynamic Dashboard for Project Durations and Costs in Excel

A Dynamic Dashboard for Project Durations and Costs in Excel

February 1, 2016

## Three Common Dashboard Mistakes

Three Common Dashboard Mistakes