How to create INTERACTIVE EXCEL CHARTS with OPTION BUTTONS
Let's learn how to create interactive Excel charts with Option Buttons. Along the way you'll discover 12 + 1 formulas and features in Excel such as the XLOOKUP, OFFSET, VLOOKUP, Named ranges, INDEX, SORT, VLOOKUP and how they play out to achieve interactive Excel dashboards.
Think about the ability to switch between one view to another, say the regions, in an Excel Dashboard instead of having to create multiple charts for the same.
🕙Moments:
00:00 Intro and example of an interactive chart
00:46 EDATE and EOMONTH for date ranges
06:15 Developer tab and inserting Option/Radio Buttons
10:11 INDEX, XLOOKUP and VLOOKUP for dates for selected period
12:10 OFFSET and MATCH for interactive chart data preparation
17:00 FILTER and SORT as alternatives for chart data preparation
20:01 Plotting the dynamic Excel chart
21:01 Dynamic named ranges for dynamic Excel charts
25:30 Formatting the chart
//WATCH NEXT
✔Use drop down lists to create interactive charts in Excel: • Interactive Excel Charts Using Drop Down L...
✔Highlight low and high points in a chart in Excel: • Highlight High Low Points in an Excel Char...
#msexcel #excelcharts #datavisualization
💡Polish up your Excel charting and data visualization skills. Get this FREE eBook:
https://datacycleanalytics.com/boardr...
⭐⭐⭐⭐Take your data storytelling and charting skills to the next level with this top rated 5 hours of video chart course: https://courses.datacycleanalytics.co...
//WORK WITH WILLIAM
👉For business inquires only, please use this email: [email protected]
_____________
SUBSCRIBE:
/ @williamthedataprof
//COME SAY HI!:
Facebook: / billwilliamsk
LinkedIn [personal]: / william-kiarie-baab977a
LinkedIn [company]: / data-cycle-analytics-ltd