Excel Forum

Excel Dynamic Chart #3: Table Feature (Excel 2010 / 2007) List Feature (Excel 2003)

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.

Got a Question? Ask it Here in the Forum.