Microsoft Office Tutorials and References
In Depth Information
Using Histograms to Track Relationships and Frequency
2. Copy the formula down for all the bins in the table.
3. Use the chart feeder table to plot the data into a line chart.
As you can see in Figure 9-16, the resulting chart needs some additional formatting.
Figure 9-16: Your initial chart will need some formatting to make it look like a histogram.
4. Right-click the series that makes up your histogram (Count of Sales Rep), select Change Chart
Type, and then change the chart type to a column chart.
5. Right-click any of the columns in the chart and choose Format Data Series.
6. Adjust the Gap Width property to 0% (refer to Figure 9-13).
7. Right-click Cumulative Percent series and choose Format Data Series.
8. In the Format Data Series dialog box, change the Plot Series On option to Secondary Axis.
9. Right-click Cumulative Percent series and choose Add Data Labels.
At this point, your base chart is complete. It should look similar to the one shown at the beginning of
this section in Figure 9-14. When you get to this point, you can adjust the colors, labels, and other
Using a pivot table to create a histogram
Did you know you can use a pivot table as the source for a histogram? That’s right. With a
littleknown trick, you can create a histogram that is as interactive as a pivot chart!