Excel 2010 Bible

Part II: Working with Formulas and Functions

298

FIGURE 13.9

A frequency distribution and chart generated by the Analysis ToolPak’s Histogram option.

Using a pivot table to create a frequency distribution ....................................

If your data is in the form of a table, you may prefer to use a pivot table to create a histogram.

Figure 13.10 shows the student grade data summarized in a pivot table in columns D and E. The

data bars were added using conditional formatting.

To make sure that the Analysis ToolPak add-in is installed, click the Data tab. If the Ribbon displays the

Data Analysis command in the Analysis group, you’re all set. If not, you’ll need to install the add-in:

1. Choose File ➪ Options to display the Excel Options dialog box.


2. Click the Add-ins tab on the left.


3. Select Excel Add-Ins from the Manage drop-down list.


4. Click Go to display the Add-Ins dialog box.


5. Place a check mark next to Analysis ToolPak.


6. Click OK.

If you’ve enabled the Developer tab, you can display the Add-Ins dialog box by choosing

Developer ➪ Add-Ins ➪ Add-Ins.

Note: In the Add-Ins dialog box, you see an additional add-in, Analysis ToolPak - VBA. This add-in is

for programmers, and you don’t need to install it.

Is the Analysis ToolPak Installed?