pivot

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot

Pivot

resolvedResolved · Low Priority · Version Standard

Dorte has attended:
Excel Advanced course

Pivot

How do I create a PivotChart

RE: 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


 

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.09 secs.