Question: Carlos is using a pivot table and chart. The chart currently has a 1 and 2 on the X axis to indicate the two groups,
Carlos is using a pivot table and chart. The chart currently has a 1 and 2 on the X axis to indicate the two groups, male and female. However, carlos wants that to say "Male" and "Female" to make the chart more clear. In his data 1=Male, 2=Female. Which step would help Carlos solve this problem?
| A. | Change the 1 to Male and the 2 to Female in the pivot table. Then the chart will update automatically. | |
| B. | Add a new column to the pivotchart fields called "Names" then add that to the filter box and use that to edit the axis labels. | |
| C. | Go into the dataset and change all of the 1s to Male and all of the 2s to Female. Then after the pivot chart updates, go back to the dataset and change all of the "Male" entries back to 1s and "Female" entries back to 2s. | |
| D. | Double click on the X axis of the pivot table and change the labels to Male and Female. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
