How to create a standard chart from some or all data in a PivotTable report in Microsoft Excel 2010 on Windows Vista
One of the most intrinsic aspects of any data is its formatting. However critical the data is, perfection of its representation adds a lot to its value. But what if you are dealing a Pivot Table, which is a data summarization tool and makes a parallel table in sync with the main spreadsheet? You can apply some basic formatting and make it look alike. The formatting option in a Pivot Table gives you the option of formatting any one particular cell or the entire table at large. It can be done by way of few formatting commands or selecting the options through your mouse. So, while you make use of a Pivot table for various calculus functions, you can ensure a neat and uniform look like that of your spreadsheet. Let us observe a few easy steps that can help you tabulate and synchronize your data in an easy manner, while working on your Windows Vista PC.
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.
So if you are running short of time and want to present a neat and synchronized data, you can rely on the PivotTables.