How do I create a PivotChart

Dear Dorte

Thank you for attending Excel Advanced Excel. I hope you enjoyed the course.

Pivot Table and Charts are used to summarize large amount of data. The reason why they are so powerful compared to Auto filters or Advanced filters is because they are Interactive and you can change the look of your spreadsheet by simply dragging and dropping the heading of the rows and columns.

I hope that you are confident in creating Pivot Tables. To create a Pivot Chart you simply click anywhere inside the pivot table and either click the Chart Wizard on the Standard toolbar or the chart button on the Pivot table toolbar.

Once more the various fields can be dragged and dropped on different parts of the chart.

I hope this helps in answering your query.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved . If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003