168k views
4 votes
On the column chart on Sheet1, delete the horizontal axis title and set a vertical axis title with the name, Students. Then, change the chart title to the name, Swimming Attendance.

User Meylin
by
8.0k points

1 Answer

2 votes

Final answer:

To adjust a column chart in Excel, simply select and delete the horizontal axis title, right-click on the vertical axis to add a new title called 'Students', and directly rename the chart title to 'Swimming Attendance'.

Step-by-step explanation:

To modify a column chart on 'Sheet1', you would first delete the horizontal axis title by selecting it and pressing the delete key. For the vertical axis title, right-click on the axis, select 'Axis Titles', and then 'Primary Vertical Axis Title'. You can type 'Students' to set it as the new title. To change the chart title, click on the existing title and type in 'Swimming Attendance' to reflect the new name of the chart.

Remember, in graphing, the horizontal axis (x-axis) typically represents the independent variable, while the vertical axis (y-axis) represents the dependent variable. In the context of your chart, 'Students' is the dependent variable as it may vary based on another factor, presumably the independent variable plotted along the x-axis. Applying descriptive titles and labels, as you are doing, is crucial for clarity and ease of understanding the data presented on the chart.

User AndreyS Scherbakov
by
7.7k points