How to create a standard chart from some or all data in a PivotTable report in Microsoft Excel 2010 on Windows XP
There is no doubt in the fact that a PivotTable is a great summarization tool that helps you synchronize your data by making sorting, summation and calculus utterly easy. Though it is identical to a generic spreadsheet, you can easily differentiate between a PivotTable and the main sheet from which it has been extracted. At times you may not want a separate visual appeal for your PivotTable. In this case you might want to format changes in the same table by working on individual cells or specific data regions by using some simple commands. Well, implementing the solution is as simple as it may read. You don’t need to have a great command over Microsoft Excel to be able to make the said changes while experimenting on your Windows XP PC. Just follow some simple steps create a standard chart from some or all data in a PivotTable.
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.
Just follow these simple steps and make an impression with a well-organized and well laid out table.