You can graph the data in a spreadsheet using Quick Graph or Summary Plot. Lists & Spreadsheet cells that contain no data are not represented by data points on graphs.
You can easily create a dot plot of the data in one column or a scatter plot of two adjacent columns by using the Quick Graph feature. This feature displays the graphed data using the Data & Statistics application.
To create a scatter plot:
1. | Name both of the columns to declare them as lists. |
2. | Select both columns. |
3. | From the Data menu, select Quick Graph. |
A Data & Statistics application is added to the page with the plotted data. The leftmost of the two lists is plotted on the x axis, and the other list is plotted on the y axis.
4. | (Optional) Use the Data & Statistics features to analyze or visually enhance the graph. |
Note: For more information, see Using Data and Statistics.
In this example, you create a summary table from raw data, and then use the table to generate a summary plot. For more information, see Using Data & Statistics.
|
|
A summary table contains an X (or Y) List and a Summary List.
• | The X (or Y) List contains numeric or string values (such as 1999 or “color”). Numeric values result in a histogram. String values identify the categories for a bar chart. |
• | The Summary List contains numeric values (such as count, frequency, or probability) for each element in the other list. |
Note: For situations in which you already have a summary table, you can skip the first two steps.
1. | Create a list that holds the category identifiers. For this example, name the list “color” and type strings for eye color. Enclose category names in quotes to prevent them from being interpreted as variables. |
2. | Create the summary list. For this example, name the list “counts” and type the total count for each of the eye colors. |
3. | Select either list by clicking the top cell of the column and pressing ▲. |
4. | From the Data menu, select Summary Plot. |
The Summary Plot dialog box opens.
5. | If necessary, use Tab and the arrow keys to select the correct lists for X List and Summary List. |
6. | In the Display On field, select how to display the summary plot in the Data & Statistics application. |
• | Select Split Page to place the chart on half of the current page. |
• | Select New Page to add the chart on a new page. |
The summary plot is displayed with the list names along the axes and a summary plot symbol in the lower left corner of the chart window.
Note: In this example, the X List contains string data, so the summary plot displays as a bar chart. The category strings from the list display beneath the bars.