Pivot

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