Creating a Dashboard in Excel

  • Creating a Table and Dashboard Space
  • Creating Charts ( Bar, Pie, Doughnut Charts)
  • Creating Indicators

1st Stage: Creating Table and Dashboard Space

Why we should create a table? we should board our data with table for allowing to update dashboard when we add new values.

Two steps here:

2nd Stage: Creating Charts ( Bar, Pie, Doughnut Charts)

- Bar Chart

1st step

2nd step

3rd step

4th step

  • font and font size
  • Bar Chart and legend color
  • Removing background and outline Charts as well as horizontal lines

- Pie Chart

1st step

2nd step

3rd step

4th step

- Doughnut Charts

3rd Stage: Creating Indicators

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abdulaziz Alsulami

Abdulaziz Alsulami

A self Learner interested for AI & Python, love reading, write his thoughts to his own way and like presenting knowledge to world in picture which he like.