Final answer:
To change the layout of data on a column chart from 'time of day by location' to 'numbers for locations by time of day', you need to switch the row and column data in the chart's source and ensure that the axes are labeled and scaled appropriately.
Step-by-step explanation:
The student is asking how to change the orientation of data on a column chart so that the columns represent numbers for locations by time of day instead of time of day by location.
To do this, you need to switch the rows and columns of data in the chart's source.
Here is a step-by-step guide:
First, select the chart that you want to modify.
Right-click the chart and find the option to 'Select Data' or access the 'Select Data Source' dialog box.
In the dialog box, you will see an option to 'Switch Row/Column'.
Select this to change the orientation of your data.
Once you've switched the row and column, the chart will update to show the data as per your new arrangement.
Verify that the data is displayed accurately, and make any necessary adjustments to the chart's layout and labels.
Remember to label each axis appropriately.
For the x-axis, use Time (min), and for the y-axis, consider a label that represents the location's data, each with appropriate units.
Ensure that your scales on both axes reflect the data range accurately.