Question

in the given diagram of a pivot chart in mricosoft excel 2016 ,the brush "symbol indicates which of tge following options​

Answer 1

Answer:

✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿

Explanation:

✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿✿●‿●✿

Answer 2

Answer:

To create a pivot chart, go to the Insert tab.

Go to the Charts group.

Here you can see Recommended Charts, graphical representations of the types of charts you can add, as well as the PivotChart button.

Click PivotChart to display the dropdown menu, then click PivotCharts again.

You will then see the Create PivotChart dialogue box.

The range of cells should already be filled in for you, just as it was with PivotTables.

Also, just as with PivotTables, you can decide if you want to place your chart in a new worksheet or an existing one. We are going to choose a new worksheet.

Click OK.

We can now start building our pivot chart.

Just as with PivotTables, we are going to go to the PivotChart Fields panel on the right to design our pivot chart.

Drag and drop the fields from the top section of the panel into the sections located in the bottom half of the panel.

These sections are Filters, Legend (Series), Axis (Categories), and Values. The Axis is essentially the row, and the Legend is essentially the column.

Below you can see the fields that we dropped into the sections.

We can see our pivot chart in the worksheet.

Notice that a pivot table also appears. You can either hide the columns of the pivot table so you cannot see them, or you can move the pivot chart to its own worksheet.

To do this, go to the Analyze tab under PivotChart Tools. Click the Move Chart button.

You will then see the Move Chart dialogue box.

Put a check beside New Sheet, then enter a name for the new sheet.

Click the OK button.