Friday, March 11, 2011

How to Create Dynamic Charts in Excel Using Data Filters


1. Organize the source data in your spreadsheet.
2. Create the type of chart specific to your data needs using the Chart Wizard tool.
3. Insert data filters to the source data by selecting 'Menu' then 'Data.' Next choose 'Filter' and then 'Auto Filter.' In Microsoft Excel 2007, use the home ribbon and then select 'Filter and Sort Button' followed by 'Filter.'
4. Apply the data filter to select the type of data you wish to use in the chart. The chart will automatically change depending upon how the data is filtered.

Blogger news