Dynamic Excel Chart | Offset | Spin Button | Slicers
Автор: Datacense
Загружено: 2020-10-26
Просмотров: 2108
Today we will learn How to create a dynamic chart in excel using Offset function, spin button, and slicers.
Dynamic charts are a great way to avoid creating similar charts again and again, hence they save a lot of effort.
In this chart we are using Pivot Tables with a slicer, Dynamic Name Ranges using offset function, and then a spin button to control the number of columns to display on the chart.
You can get the practice file from the link below
https://bit.ly/2HEuBTr
Index
00:00 Intro
01:17 Step 1 Pivot Table
02:15 Step 2 Dynamic Name Ranges
04:15 Step 3 Create a Chart
05:00 Step 4 Create Dynamic Title
05:57 Step 5 Add Slicer
06:46 Step 6 Add Spin Button
Also, check these videos if you want to learn more
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
How to Create Dynamic Named Ranges using Offset
• How to Create Dynamic Named Range | Offset...
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: