Grapher creates graphs from numeric or date/time data. If you have categorical data which are not numbers, the sequence or row number for that category can be used to represent the data. By following the steps below, you can then use your category worksheet values to label your axes.
Scatter Plots
If your data looks similar to this, follow steps below to create a scatter plot from category data in Grapher:
Most Popular Majors | Number of Bachelor's Degrees |
Engineering, General | 269 |
Petroleum Engineering | 106 |
Geoscience Engineering | 58 |
Chemical Engineering | 54 |
Engineering, Physics | 52 |
Other | 182 |
- Open a new plot document. Then click the Home | New Graph | Line/Scatter | Scatter Plot command.
- Select the data file and click Open. The default graph is created using the only numeric column for both the X and Y axis.
- Click on the scatter plot in the Object Manager.
- In the Property Manager, click on the Plot tab.
- Select Row number or Sequence number from the X variable list.
- Verify that the Y variable is set to Column B.
- Click X Axis 1 in the Object Manager to select it.
- In the Property Manager, click on the Labels tab.
- In the General section, select From worksheet in the Label source field.
- Click in the Worksheet field and select your data file from the list.
- Click in the Data variable field and select Row number or Sequence number from the list. (Be sure to choose the same X variable list option you previously chose in step 5.)
- Click in the Label variable field and select Column A from the list. Your graph should now contain categories for the X axis labels.
Note:
Depending on which rows are displayed, you may need to open the Worksheet range section and change the First row and Last row values.
If your labels are overlapping, expand the Label Settings section, and increase or decrease the Angle (90 is vertical) in the Label Position section.
Bar Charts
Follow these steps to create a bar chart from category data in Grapher:
- Click the Home | New Graph | Bar | Horizontal Category Bar Chart command.
- Select the data file and click Open.
- The default graph is created with the category labels automatically displayed.
Updated May 2023
Comments
Please sign in to leave a comment.