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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!