I am new to VBA programming for Excel, and I need some help on how to
accomplish the following:

I have an existing spreadsheet with 5 charts. I would like to create
option buttons to allow the user to see one chart at a time.
Currently all the charts are displayed on one worksheet, and various
inputs in the workbook affect the charts. When I code Option Button
Click, how do I manage to display the different charts for the
different buttons. Any tips or suggestions would be greatly
appreciated.