8.4 Box Plot
- Select the cells with the temperature values in Column B.
- Go to the Insert tab. Select
Box and Whisker
in theCharts
ribbon (Figure 8.1).
![A screenshot of the Box and Whisker option in Chart ribbon of the Insert tab.](images/box-and-whisker-menu.png)
Figure 8.1: Box and Whisker option in the Chart ribbon of the Insert tab.
The resulting plot is shown in Figure 8.2.
![A screenshot of the Box and Whisker created.](images/box-and-whisker-plot.png)
Figure 8.2: Box and Whisker created.
- Replace Chart Title with NY Temperatures in September 2013.
RIGHT-click
on the vertical axis and then selectFormat Axis
to change the axis format in the graph. Set the Minimum Bound as 45. Adjusting the axis removes the unnecessary space in the chart.
![A screenshot of the Format Axis options.](images/format-axis.png)
Figure 8.3: Format Axis options.
Use the Chart Design
to customize the look of your chart.
- Select the graph, and the tab
Chart Design
appears in the menu. Click on theChart Design
tab. - Click
Add Chart Element > Data Labels > Right
. - Click
Add Chart Element > Axes
. Uncheck the optionPrimary Horizontal
.
The adjusted box plot is shown in Figure 8.4.
![Adjusted box plot.](images/final-box-plot.png)
Figure 8.4: Adjusted box plot.