Interactive dashboards in Google sheets

Google Sheets allows you to create charts and choose to aggregate easily, and if you add Slicers then it can become interactive. Card visuals and Table visuals are interesting to explore as Excel doesn't have them, plus using Pivot Tables allows you to sort the charts or have crosstab analysis which can be made more visual through sparklines and conditional formatting. I cover all this in my video.

Other links:

00:00 Introduction
00:37 Create an aggregated chart
02:30 Card visuals
03:18 Pivot Tables and sorted charts
04:22 Chart only dashboard
06:09 Slicer for interactivity
11:03 Pivot table date groups
12:21 Paginated table chart
13:20 Conditional format and sparklines
14:34 Colour picker to match logo etc
16:04 Final dashboard touches
16:38 Marker 11

[gabrielvasquez]

This is some of the best and most useful content I've found on Google Sheets. Thanks!

[EhabGheidan]

Thank you so much for the efforts in doing this video, it is really amazing

[nerlyherrera]

I'm pretty new with sheets but was tasked to make a dashboard, and man, I was banging my head against the wall because I could NOT figure out why my slicers weren't affecting the chart, THANK YOU!!

[joshr]

Thanks for this! I work predominantly with Google Workspace and this video has really helped me, I'm able to apply the logic you've displayed here to some of the things that I'm currently working on

[thebesttechnical]

Thanks a lot for this simple yet powerful explanatory tutorial

[sovecheasophanna]

Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.

[IbrahimBashir]

Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.

[itskristieali]

Literally the most helpful video!! Thank you!

[AurélieNathalie-xr]

Thank you for this video! it interested me a lot and helped me too

[mitooquerer]

Thanks! Just what I was looking for. 😊

[Tigrenocchek]

Very usefull information, thank you for this video!

[sivaasflame]

I have made an dashboard recently in goodle sheets . When i download as xlsx file (for github upload ) and open it using excel, it completely collapsed all the alignment. What should i do??

[mycafalcunaya]

Hi, how to keep the charts in position when using slicer? Whenever I use slicer the charts I made keeps on being a mess again

[jasonmotley]

I'm trying to test if the Dashboard works when "Published to the Web" ... Does it? Doesn't seem to work for me.

[Awahab]

Thanks For teaching sir... How you are showing this whole project in full screen even in 150%zoom 🤯 🤷‍♂️. GIVE TRICKS SIR

[spdby]

Hi. This video is really easy to understand.
The link doesn't seem to work for me, is there another way I get access to the files?

[safamoh]

thank you for this video . I could not download the data to practice .

[JoseAntonioMorato]

You make the example file available for download, but the difficult part is knowing what it is among a bunch of files stored on YT public files.
There is no file named "Interactive dashboards".

[solooutvlog]

How to show charts when freez a row .it disapear

[larsenmoura]

This is some of the worst instructions I’ve ever seen in my life please find a new job