Consulting | Excel Examples

Chart Controlled With Button

Keywords: Chart, Dialogs method

Description: Example of control buttons on a chart used to change the 3D view and trend line settings.

Tip: You can use a very simple Visual Basic for Applications procedure to call any one of Excel's hundreds of built in dialogs. This example shows the Dialogs method used to call the 3d view and trend line dialogs.

Guide to the Example: Data for the charts is contained in worksheet "Chart Data". Buttons on sheets "Chart1" and "Chart2" call procedures in Module1.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

Last modified: May 21, 1996