How to create a standard chart from some or all data in a PivotTable report in Microsoft Excel 2010 on Windows 7
Proper summarization of any given data is a very important aspect. Be it sorting, totaling, averaging or counting, a data goes through various processes so that it can be used in a prudent manner. A Pivot table in this case does wonders. An automated tool, it displays the result in a separate table at the click of a command. While it is a great way to demarcate your larger data and the results, it may not look like your main spreadsheet. However, it does provide you formatting options that can help you make it as a complete replica of your main data table. You can apply these changes to a particular cell or to the table at large with the help of a few easy steps. These steps not only help you organize your data but also establishes a connect between the two tables. 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.
Well, that’s how you can manage your PivotTable data in no time