Excel infographic charts: 26 dashboard charts step by step

LangAdvance Portuguese

Learn to build 26 infographic charts in Excel, from speedometers and battery charts to Gantt and tornado charts, ready to use in any dashboard.

Get the project files and follow along: https://allgoodtutorials.com/supporters/videos/build-26-infographic-charts-in-excel

What you will learn:
Build KPI, progress bar, battery and speedometer charts that update with your data
Turn bar charts into pictographs with shapes, icons and images
Compare results with tornado, lollipop and spider charts
Plan projects with a Gantt chart and a milestone timeline
Add list boxes, spin buttons and a PivotTable timeline
Flag results with traffic signals, heat maps and data validation

Chapters:
00:00 Course intro
04:17 KPI chart
21:13 Gantt chart
35:16 Capsule chart
44:46 Tornado chart
58:51 Target vs achieved chart
1:13:43 Progress bar chart
1:27:21 Pyramid chart
1:34:39 Traffic signal chart
1:57:47 Lollipop chart
2:05:50 Moving trophy chart
2:20:17 Spider chart
2:29:12 Validation chart
2:35:44 Star rating chart
2:51:44 Dynamic cylinder chart
3:07:10 KPI cylinder chart
3:28:18 Circle chart
3:40:15 Human chart
4:00:51 PivotTable timeline filter
4:09:17 Bullseye chart
4:30:56 Balloon chart
4:40:56 Survey chart
4:57:58 Bike race chart
5:11:27 Project timeline chart
5:23:32 Battery chart
5:37:50 Heat map chart
5:42:26 Speedometer chart
5:58:12 Flight chart
6:08:15 Course wrap-up

The project files are on the course page, included with All Access (7-day free trial) or with the course ($19).

All Good Tutorials publishes step-by-step video courses for the software you use at work: Microsoft Office, Google Workspace and more.
Start free or try All Access free for 7 days: https://allgoodtutorials.com/supporters/pricing?utm_source=youtube&utm_medium=description

#Excel #ExcelCharts #DataVisualization