3.6 Adjusting the Horizontal Axis

3.6.1 MAC

  1. RIGHT-click on any vertical bar of the graph. From the menu, click the option Select Data.
  2. Click Edit under Horizontal (Category) Axis Labels. Click and drag over the range E8:E12 (midpoints).
  3. Click OK. This is to re-label the x-axis with the midpoints replacing the upper limits.
  4. Click OK again.
A screenshot of the dialog window on a MAC to adjust the horizontal axis of the graph.

Figure 3.6: Adjusting the horizontal axis on a MAC.

3.6.2 PC

  1. RIGHT-click on any vertical bar of the graph. From the menu, click the option Select Data.
  2. Click Edit under Horizontal (Category) Axis Labels.
A screenshot of the dialog window on a PC to adjust the horizontal axis of the graph.

Figure 3.7: Adjusting the horizontal axis on a MAC.

  1. Click in the filed Axis label range, delete whatever values are in there, and drag over the range E8:E12 to select midpoints cells.
  2. Click OK. This is to re-label the x-axis with the midpoints instead of the upper limits.
  3. Click OK again.
A screenshot of the dialog window to relabel the horizontal axis on a PC.

Figure 3.8: Relabeling the horizontal axis on a PC.