next up previous contents
Next: Help Up: Chart Previous: Show

Add...

To add a histogram to your spreadsheet, select the region to be added to the chart, then select Add... from the Chart menu or toolbar. The Options dialog for the histogram will appear.

../images/histogram-1.jpg

All the fields in the Options pop-up are already filled in based on the range you selected. These are guesses that are made for you, and most likely have to be filled in with other values to generate the exact histogram you want. The Chart Title field, for example, should be something more descriptive than the default. The Bucket field is very important. The histogram is generated by tallying up the number of values that fall into the range divided up into buckets. The X Scale and Y Scale can also be set to appropriate values. Finally, the histogram can be displayed by either percentage or count by selecting the radio buttons at the bottom.

../images/graph1.jpg

The histogram can be updated when the values in the cell range change by clicking the Update button.

../images/graph2.jpg

You can also add other other histograms. The titles of each histogram will be displayed in tabs at the top of the Histogram pop-up.

../images/graph3.jpg
next up previous contents
Next: Help Up: Chart Previous: Show
Daniel Medina
2000-12-10