USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Leigh Ann designed a bar chart and would like to add an element to theright of the chart that identifies each bar’s color. Which chart featurewould she need to include?
|
|
Axis
|
|
|
Chart Title
|
|
|
Data Label
|
|
|
Legend
|
Explanation:
Detailed explanation-1: -Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Design, and then click the More button in the PivotTable Styles gallery to see all available styles. Pick the style you want to use. If you don’t see a style you like, you can create your own.
Detailed explanation-2: -Select the cell or range of cells for which you want to add a fill color. On the Home tab, click Fill Color, and pick the color you want.
Detailed explanation-3: -To do that, see Create a PivotTable to analyze worksheet data. Select a cell in your PivotTable. On the Insert tab, select the Insert Chart dropdown menu, and then click any chart option. The chart will now appear in the worksheet.
There is 1 question to complete.