Excel Yourself/Excel Dashboards #1 - Guidelines - 2024

Dashboard #1 - Guidelines

In this recorded session we focus on chart and dashboard guidelines plus some techniques used to create small charts for dashboards.


We also look at creating a bullet chart, which is an alternative to gauge, speedo or dial chart.


The session covers

  • general chart guidelines

  • questions to ask yourself to develop better charts

  • best charts to use

  • charts and formats to avoid

  • using text boxes on dashboards

  • how to create small charts

  • chart templates

  • lining up and re-sizing charts

  • useful number formats for dashboard charts

  • using the #N/A error with charts

  • how to create a bullet chart

Recorded: March 2024
Level: Intermediate
Duration: 1 hour
Price: Free

  • Free

Excel Dashboards #1 - Guidelines - 2024

Lots of ideas to improve your charts and dashboards.

Contents

Course materials

The pdf manual plus the Excel file to work through during the session and the completed file.
Dashboard_Guidelines_2024.pdf
  • 780 KB
Dashboard_1_Guidelines_2024.xlsx
  • 176 KB
Dashboard_1_Guidelines_2024_completed.xlsx
  • 194 KB

Course Video recording

Dashboards #1 - Guidelines - video recording
  • (1h 06m 11s)
  • 228 MB