change the title of the chart by selecting the text and entering the title you want. After I made some of
these changes, the histogram appears as its shown in Figure 41-4.
F41xx04
FIGURE 41-4
Changing the format of different elements in the chart.
F41xx04: This figure shows the histogram with no gaps and a smaller font size.
Notice that Cisco returns are most likely between 0 and 10 percent per month, and the height of
the bars drops off as the graph moves away from the tallest bar. When you create the histogram, you
also obtain the bin-range frequency summary shown in Figure 41-5.
F41xx05
FIGURE 41-5
The Cisco bin-range frequencies.
F41xx05: This figure shows the bin-range count and finished histogram.
From the bin-
range frequencies, you can learn, for example, that for two months, Cisco’s return
was greater than
–
30 percent and less than or equal to
–
20 percent; for 13 months, the monthly
return was greater than
–
20 percent and less than or equal to
–
10 percent.
If you add new Cisco monthly returns or even if you just modify the existing monthly returns, your
histogram will not change unless you rerun the Data Analysis histogram procedure.
Excel 2016 provides an easy option to create better-looking histograms that automatically update
