Information Communication Technology ICT – 16 Graphs and charts | e-Consult
16 Graphs and charts (1 questions)
Login to see all questions.
Click on a question to view the answer
To adjust the axis scales and set incremental values in a spreadsheet program, the student would follow these steps:
- Select the y-axis: Click on the vertical axis of the chart to select it.
- Access Axis Options: Right-click on the selected axis and choose "Format Axis" (or a similar option depending on the spreadsheet program). This will open the formatting options for the axis.
- Adjust Maximum Value: In the "Format Axis" options, locate the "Maximum" field. Enter the value 100 into this field. This sets the upper limit of the axis.
- Adjust Minimum Value: Locate the "Minimum" field. Enter a suitable minimum value. Consider the data being represented. If the number of students who enjoy music starts at 0, then 0 would be a suitable minimum. If the data starts at a different value, adjust accordingly.
- Set Incremental Values: Look for an option related to "Major Tick Marks" or "Major/Minor Tick Marks". This section allows you to define the intervals at which the tick marks appear on the axis. Set the "Major Tick Marks" to 10. This means the axis will have tick marks at 0, 10, 20, 30,... up to 100. The spreadsheet program will automatically display the corresponding values on the axis.
- Check the Chart: Review the chart to ensure the axis scales and increments are displayed correctly and are easy to read.