Creating histogram charts
Histograms let you graphically display continuous or discrete data by grouping data into a series of bins representing a certain range of values, with the frequencies of each of these bins displayed in the form of a bar on a chart. Histograms are useful for examining the distribution of data in different ways by changing the number of bins and the data ranges they represent.
For information about modifying charts, see “Working with chart series.” For information about editing charts, see “Editing charts.”
To create a histogram chart |  |
|
1.
|
|
Select the cells you want to plot.
|
|
If the surrounding cells contain explanatory labels, you can include them in the selection for use as the chart axis labels or the chart legend.
|
|
2.
|
|
Insert
 Chart Use Chart Expert. |
|
3.
|
|
Click Next.
|
|
4.
|
|
Choose Histogram from the Category list.
|
|
5.
|
|
Click Next.
|
|
6.
|
|
Type in any of the following boxes:
|
|
•
|
Title
|
|
•
|
Subtitle
|
|
•
|
X-axis
|
|
•
|
Y-axis
|
|
•
|
Footnote
|
|
7.
|
|
Click Next.
|
|
8.
|
|
Choose a color scheme option from the Choose a color scheme list.
|
|
9.
|
|
Click Finish.
|
|
10.
|
|
Drag in the spreadsheet.
|
|
•
|
|
You can add depth to a chart by enabling the Add depth check box. You can also apply advanced rendering to a chart by enabling the Advanced rendering check box.
|