Microsoft
77-727 · Question #35
On the "Summer Sales" worksheet, switch the rows with the columns on the first column chart.
1. Select the first row column on the "Summer Sales" worksheet and Copy either from the Home tab OR by pressing Ctrl+C on the keyboard. 2. Select the first cell where you want to paste the data, then click on the arrow next to Paste situated on the Home tab, then select…
Create charts and objects
Question
On the "Summer Sales" worksheet, switch the rows with the columns on the first column chart.
Explanation
- Select the first row column on the "Summer Sales" worksheet and Copy either from the Home tab OR by pressing Ctrl+C on the keyboard.
- Select the first cell where you want to paste the data, then click on the arrow next to Paste situated on the Home tab, then select Transpose.
- If you get a message saying the destination area has data, pasting will overwrite the already existing data that is already there.
- Once completed, you can delete the original data if desired.
Topics
#switch rows columns#chart data orientation#column chart#Select Data
Community Discussion
No community discussion yet for this question.