In this Excel dashboard example, you can select "Chart" or "Chart Data" from a drop down list. Magically, with no macros in the workbook, the selected item appears on the worksheet.
With this technique, you can store your data and chart on a hidden sheet in the workbook, where no one can mess with the numbers. (Not that anyone would!)
How It Works
To download the sample file, you can visit the Excel Sample Files page on the Contextures website:
- CH0002 – Show or Hide Excel Chart (click on the Excel 2010 version of the zipped file)
There is also an Excel 2003 sample file, if you're using an older version of Excel.
Watch the Video
To see the steps for creating this dashboard feature, please watch this short Excel video tutorial.
Or watch on YouTube: Show Excel Chart or Data on Dashboard with No Macros