Have some fun with simple Excel dynamic charts.
Free Microsoft Office Tutorials
Let’s have a bit of fun with Microsoft Excel dynamic charts. I’m going to show you a very interesting and simple way to make excel dynamic charts on the sheet. Or at least to make the charts appear dynamic. To do this we will use the auto filter to only show the chart that we want. This is a neat trick.
Watch this video tutorial for step by step instructions on Excel dynamic charts trick.
The trick is to put the charts into individual cells directly underneath each other. Use the auto filter to have only one chart showing. When you choose a different criteria from the auto filter a new chart appears in its place. When you send the workbook out sent it with the auto filter enabled and filtered to a chart. Include simple instructions to show how to operate the excel dynamic charts.
You’ll be able to download the workbook and have a look at exactly how it is set up. It is so simple and so effective.
Download the file here
Let me know your comments
Excel Dynamic Charts Trick – Easy as ABC – Excel Dynamic Charts