Best Charts to Compare Actual Values with Targets – What is your take? - EBOOK VBA EXCEL

EBOOK VBA EXCEL

EVBA.info ( Ebook VBA Excel ) Welcome EVBA.info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Free Courses, Living Skills ...

Monday, May 27, 2019

Best Charts to Compare Actual Values with Targets – What is your take?

Best Charts to Compare Actual Values with Targets – What is your take?

I have added my comments to each option along with useful links to learn how to make such a chart.
There is a poll too, at the end.

(1) Gauge / Speedometer Chart

Gauge / Speedometer Chart - Comparing Performance using Charts

What is good about this approach?

  • Familiar metaphor thus easy to understand
  • Easy to construct
  • Good for communicating one data point

What is bad?

  • Takes too much space
  • Bad design choice for most professional situations

Tutorials to make Gauge / Speedometer Chart

(2) Thermometer Chart

Thermometer Chart - Comparing Performance using Charts

What is good about this approach?

  • Familiar metaphor thus easy to understand
  • Easy to construct
  • Good data to ink ratio

What is bad?

  • Do not say anything about trends
  • Not appropriate when actual values exceed targets

Tutorials to make Thermometer Chart

(3) Bullet Chart

Bullet Chart - Comparing Performance using Charts

What is good about this approach?

  • Comprehensive
  • Aesthetic and very good data to ink ratio

What is bad?

  • Difficult to construct in Excel
  • Takes time to read the first time

Tutorials to make Bullet Chart

(4) Area Chart

Area Chart - Comparing Performance using Charts

What is good about this approach?

  • Shows trend along with current status
  • Easy to construct
  • Easy to compare

What is bad?

  • Not good for small data sets

(5) Line Charts

Line Charts - Comparing Performance using Charts

What is good about this approach?

  • Easy to construct
  • Shows trend along with current status
  • Easy to read and understand

What is bad?

  • Looks too simple

(6) Column Chart with Markers

Column Chart with Markers - Comparing Performance using Charts

What is good about this approach?

  • Easy to compare & read
  • Easy to construct

What is bad?

  • Not good for small data sets

Tutorials to make Column Chart with Markers

(7) Partially Overlapped Chart

Partially Overlapped Chart - Comparing Performance using Charts

What is good about this approach?

  • Easy to construct

What is bad?

  • Difficult to compare

(8) Traffic Lights

Traffic Lights - Comparing Performance using Charts

What is good about this approach?

  • Familiar metaphor thus easy to understand
  • Easy to construct (with Excel 2007 Conditional Formatting)
  • Good for tables

What is bad?

  • Do not tell the entire story, so should be used only in tables or with other displays

(9) Pie Charts

Pie Charts - Comparing Performance using Charts

What is good about this approach?

  • Familiar metaphor thus easy to understand
  • Easy to construct (with Excel 2007 Conditional Formatting)
  • Good for tables

What is bad?

  • Works when targets are 100%
  • Cannot show when actual values are more than targets
  • Pie charts can be hard to read

Tutorials to make Pie Charts

(10) Using Text – Just say the thing

Using Text - Just say the thing - Comparing Performance using Charts

What is good about this approach?

  • Easy to read
  • Highest Data to ink ratio
  • Very easy to construct

What is bad?

  • Too simple
  • Leaves the finer details out
What chart do you prefer to compare actual values with targets?
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment