Uma has just created a chart, however she doesn’t like how it looks like she feels that the legend and x-axis have been swapped. How can she rectify this problem?(One or more answers are possible — partial credit will be awarded)1 pointWhilst clicked on the chart go to the field list and drag the fields between the Legends fields and axis fields.Whilst being clicked on the chart, go to the Analyze tab in the ribbon and navigate to Switch Row/Column Data. Right-click on the chart and navigate to Select Data, click on it and an option to Switch Row/Column will be found.Whilst being clicked on the chart, go to the Design tab in the ribbon and navigate to Switch Row/Column Data.
Question
Uma has just created a chart, however she doesn’t like how it looks like she feels that the legend and x-axis have been swapped. How can she rectify this problem?(One or more answers are possible — partial credit will be awarded)1 pointWhilst clicked on the chart go to the field list and drag the fields between the Legends fields and axis fields.Whilst being clicked on the chart, go to the Analyze tab in the ribbon and navigate to Switch Row/Column Data. Right-click on the chart and navigate to Select Data, click on it and an option to Switch Row/Column will be found.Whilst being clicked on the chart, go to the Design tab in the ribbon and navigate to Switch Row/Column Data.
Solution
Uma can rectify the problem in the following ways:
-
While the chart is selected, she can go to the field list and drag the fields between the Legends fields and axis fields. This will swap the legend and x-axis.
-
While the chart is selected, she can go to the Analyze tab in the ribbon and navigate to Switch Row/Column Data. This will swap the data in the rows and columns, which may rectify the problem.
-
She can also right-click on the chart and navigate to Select Data, click on it and an option to Switch Row/Column will be found. This is another way to swap the data in the rows and columns.
-
Lastly, while the chart is selected, she can go to the Design tab in the ribbon and navigate to Switch Row/Column Data. This is another way to swap the data in the rows and columns.
Remember, she may need to try more than one of these solutions to fix the problem, as it depends on how the chart was initially set up.
Similar Questions
Charts don't connect to the original data once they are made True False
Charts cannot be moved from one sheet to another, they must be remade on each sheet in order to preserve data integrity True False
Chart outputs could be the same whether they are done on row or column data True False
Chartscan have multiple charts layered on top of eachothercan switch rows and columns only for ordinalsrequire multiple datapoints as referencesall of the abovenone of the above
As you enter data in the Excel worksheet that opens when you insert a chart, you can see the chart change on the slide. A. True B. False
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.