Data forms an important aspect of most things we do…be it juggling with numbers at work, while studying or managing simple accounts at home. One of the most organized ways of putting data together is by flowing it in a chart. But at times complex data does require a summarization tool like a PivotTable. A data visualization tool, it supports the spreadsheet by offering automated sorting, counting, totaling or averaging the data stored in one table or spreadsheet by displaying it in a separate Microsoft Excel 2007 table. But did you know despite its peculiar features, PivotTables do offer a lot of room for customization and allows you to create standard charts while working on your Windows 7 PC? A few easy steps and you can arrange your data in a structured manner in the desired format. Let us see how:
1. Open Microsoft Excel file
2. Select the data in the PivotTable report that you want to use in your chart.
3. On the “Home” tab, in the “Clipboard” group, click “Copy”.
4. Click a blank cell outside of the PivotTable report.
5. On the “Home” tab, in the “Clipboard” group, click the arrow next to “Paste”, and then click “Paste Special”.
6. Click “Values”, and then click “OK”.
7. On the “Insert” tab, in the “Charts” group, click a chart type.
By now you will agree that calculus was never that easy….