Microsoft Office Tutorials and References
In Depth Information
One More Example
of Figure 11.8 shows two sets of columns. The columns that show the BINS values
(data series: 70, 80, 90, . . . 130) and the second set of columns (data series) that
correspond to the calculated frequency values. You will have to remove the BINS
data series and insert these values (70, 80, 90, . . . 130) on the X-axis. To remove the
BINS series and to force the BINS values to appear on the X-axis:
Right-click the chart.
In the Select Data Source dialog box, remove the BINS series from the Y-axis.
In the same Select Data Source menu, click on Edit to have a pop-up window
allowing you to select the Axis Labels.
Select the data for the X-axis.
The only manipulation left to do is to remove the gaps as you did before. See
ONE MORE EXAMPLE
On the sheet HHold Income in the Excel Chapter 11 file, we have the data of 1,000
customers. What you may want to do is find out the distribution of the data as you
did in the example above.
First, start by selecting the range A2:A1001 and name the data Income. After
selecting A2:A1001, just type the name Income in the Name box and hit Enter.
Proceed to find the highest and lowest values of the range as I did in cells C3 and C4.
See Figure 11.9.
FIGURE 11.9 The HHold Income Example