USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
John wants to change the chart style on his Pivot table. Which PivotTable chart tools tab would he choose?
|
|
Design
|
|
|
Layout
|
|
|
Format
|
|
|
Analyze
|
Explanation:
Detailed explanation-1: -Change PivotChart Type Click the Design tab on the ribbon. Click the Change Chart Type button. Select a new chart type and click OK.
Detailed explanation-2: -An Excel pivot chart layout is tied to the layout of the pivot table it’s connected to. If you change the pivot chart layout, the pivot table will also change, and vice versa.
Detailed explanation-3: -Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
There is 1 question to complete.