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).
The resulting plot is shown in Figure 8.2.
- 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.
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.