There are many ways to create dynamic charts in Excel, but today I want to share with you one of the most simple. In fact I think it is THE simplest way I think I know to create fun simple but impressive dynamic charts.

Let’s for an example say we want to show sales figures for widgets for three months .

1. First of all create a data set with some sales figures. Use the download the example template at the end of the post if you want to.
2. Create three standard bar charts one for each month.
3. Name three corresponding cells with your month names
4. Change the cell heights in each of the cells- this is where your graphs will sit.
5. Next put a simple filter on your cells to show your months sales.

Click away on the filter, sit back and enjoy!!!

There you have it a really fun, quick simple way to create a stunning interactive dynamic graph in Excel.

Go ahead and give it a go impress your colleagues.

Download the template and example workbook right here.{filelink=2}

You may also like these posts on Excel Charting.

1. Create a self expanding chart in Excel

2. One Click Super Quick Charting

How do you rate this technique for creating dynamic graphs compared to the alternatives using the Index()function?.