This lesson in the Mastering Excel series covers charts, specifically interactive charts.
This lesson continues to build upon the “Mastering Excel: User Forms” lesson. The User Forms lesson covered the various form objects and how to use them. The focus in this lesson is on combining user forms and charts. You will learn how to set up charts so users can interact with them via option buttons, spin buttons, scroll bars, etc. The last exercise shows you how to build a dashboard where users will be able to change the entire dashboard as it suits them. Users can change column charts to bar charts, pie charts to 3D pie charts, etc. You will learn to build one dashboard that can morph into an entirely different dashboard.As with all my lessons, there are follow along workbooks that you can use to work through the exercises at your own pace.
Follow Along Workbooks
If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.
If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.
Enter your name and email below to get your follow along workbook