Google Sheets: Visualize Data in a Dashboard with Charts, Pivot Tables, and Slicer filters Combined

Create a Dashboard in your Google Sheet with charts, pivot tables, and slicers. If all the charts, slicers, and pivot tables come from the same data source, the Slicer filters will automatically update the charts and tables. AND even those with only View access to the sheet can use the Slicers to adjust data. [Follow along with demo sheet and slides below.]
#googlesheets #googlesheetsdashboard #spreadsheettutorial #googlesheetstutorial
Copy Demo Sheet: doittraining.page.link/copyvi...
Slides: docs.google.com/presentation/...

[@rahamatullah8005]

I was looking for this one. Watched lots of videos but this one is perfect. Well explained. Thanks a lot.

[@tediaxmonetize]

THIS WAS SO SO USEFUL THANK YOU !

[@MohammadEkram-hm9ug]

Thanks for Giving Free Demo Sheet .

[@mahbub-e-ilahi5953]

Thanks so much. very nice explaination

[@gboyegaahove6961]

Very cool. Ama try it out.

[@deepikavinod1867]

Thank you so much for your video..
But I have one doubt here. I used Google sheets and created a pie chart in a dashboard sheet that pulls data from another sheet, similar to what you have shown in the video.
But after downloading the excel file, I am no more able to see the pie chart in that sheet. Could you please help me know the reason for this?

[@DeepInfosystem]

Thank you

[@JarcoPenning]

great video!

[@elghanae]

thank you very much

[@mwlammbi2650]

Awesome

[@omaryahia]

wow, thank you

[@hounamao7140]

I copied and pasted my slicer on another sheet with the chart. The chart works with the previous sheet slicer, and the pasted slicer does nothing. Any idea why ?

[@MrMosoani]

This is so awesome. Subscribed!
I wanna create a dashboard showing the impact to the resolution rate by call driver or top driver. Anyone knows how do it or point me to the tutorial video?

[@DoITTrainingSBU]

I would also explore Google Data Studio: analytics.google.com/analytics/academy/course/10

[@abdoshama6528]

how can i make slicer friendly with mobile app ????

[@datasciencedoctor]

OMG! People are literally doing back-flips and summersaults- having heart attacks and breaking body parts (spending hours)- to do what you just did in less than 5 minutes!!! Did I say OMG!!!

[@enerialufan]

How do I create a summary dashboard, detailed dashboard and a printable list dashboard?

[@selvarajandiappa3143]

Hi.. Just to check.. can you help us set up..we give you the fields and requirements..we will be happy to pay you for the services

[@JaiDhimar]

Does the slicer an pivot table need to be on the same tab?

[@DoITTrainingSBU]

The data they're based on needs to be the same dataset (the same columns of the same sheet) support.google.com/docs/answer/9245556?hl=en

[@jamlzs]

don't need to be on the same tab. That's why in the video you can see how she copy-and-paste them across different tabs but the "Dataset" so called the "source" on which the Slicer and Pivot tables are based need to be the same..