More Interactive Charts

This lesson continues to build upon the skills you learned in Mastering Excel: User Forms. You will build several charts, each of which uses a different type of form to control an Excel chart. You will learn how to use option buttons, spin buttons and check boxes. The last exercise will teach you how to build a dashboard where your users can change use forms to change the dashboard itself. User can make line charts change to pie charts, column charts change to bar charts. All without macros. Do this once or twice with a dashboard you build and you will undoubtedly be considered the Excel guru.

If you do not see the form below, please turn off your ad blocker and try again. If that still doesn't work, try another browser.

Comments on this entry are closed.

Previous post:

Next post: