Download Excel Start File: [ Ссылка ]
Download Excel Finished File: [ Ссылка ]
THE BEST dynamic chart trick around: If you setup data with the Excel 2010 / 2007 Table Feature (2003 List Feature) these things are possible:
1)Sort change chart
2)Unbelievable filtering options in Excel 2007 / 2010
3)Dynamic ranges for data added to the bottom of the table
4)And the most amazing aspect is that Sort, Filter and dynamic ranges all work together
Chart created from transactional data not aggregated data.
![](https://i.ytimg.com/vi/M9hhUVljTx4/mqdefault.jpg)