Page 275 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

5 You will find the visual in the same worksheet next to your PivotTable. You can move it to a different location
by dragging and change its size using the resize handles, just as you would with any Other graph in Excel.

Pivot chart shortcut key
To swiftly make a graph based on a pivot table, you can use the following keyboard shortcuts:
1 Select any cell within the pivot table.
2 Press the F11 key to create a graph in a new Chart sheet.

3 Alternatively, use the Alt + F1 shortcut to insert a chart on the active sheet.
The newly created pivot chart will automatically use the default type. From there, you can easily modify it to suit
your preferences by selecting a different chart type.

How to modify a pivot chart
Pivot charts are not just powerful visualization tools; they’re also incredibly flexible, allowing you to tweak nearly
every aspect to suit your needs.
To show, hide or format graph elements like axes, labels, and legend, simply click the Chart Elements button (a
plus sign) at the upper right.
Corner of the graph:

262

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77