Use a Dropdown to Switch between Charts

If you've got a table to show different views of a data series, you might want to show it one at a time. For example you may want to compare the sales, costs and profits of different items, but not all at the same time. Instead of creating three separate charts, you have a drop down for selection and it will show the respective view of your data. See the video to learn how to use a drop down combo box form control to switch between different charts in your worksheet.