Follow

How do I show categories instead of numbers on my Grapher axis?

Grapher requires numeric or date/time data to create a graph. If your data are in categories, the sequence or row number can be used as a numeric representation of the category data.  The worksheet value can then be used to label the axis by following the steps below.


If your data looks similar to this:

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

 

Follow these steps to create a scatter plot from categroy data in Grapher:

  1. Click the Home | New Graph | Basic | Scatter Plot (Grapher 12 scatter plot) command.
  2. Select the data file and click Open.  The default graph is created using the only column of numeric data as both X and Y.
  3. Click on the Scatter plot in the Object Manager.
  4. In the Property Manager, click on the Plot tab.
  5. If your data is in columns:
    1. Click in the X variable field and select Row number or Sequence number from the list. The difference between Row number and Sequence number is that Row number always use the row of the value. Sequence number starts numbering at 1, regardless of which row the data is in. 
  6. If your data is in rows:
    1. Check the Data in rows box
    2. Click in the X variable field and select Column number or Sequence number from the list. The difference between Column number and Sequence number is that Column number always use the column of the value. Sequence number starts numbering at 1, regardless of which column the data is in. 
  7. Verify that the Y variable is set to Column B or Row 2 (depending on your data layout).
  8. Click on the X Axis 1 in the Object Manager to select it. 
  9. In the Property Manager, click on the Labels tab. 
  10. In the General section, click on Automatic in the Label source field and select From worksheet.
  11. Click on None in the Worksheet field and select the data file from the list.
  12. If your data is in columns:
    1. Click in the Data variable field and select Row number or Sequence number from the list. Be sure to select the same option as selected in step 5.1 above.
    2. Click in the Label variable field and select Column A from the list. Your graph should now contain categories for the X axis labels.
  13. If your data is in rows:
    1. Check the Data in rows box
    2. Click in the Data variable field and select Column number or Sequence number from the list. Be sure to select the same option as selected in step 6.2 above.
    3. Click in the Label variable field and select Row 1 from the list. Your graph should now contain categories for the X axis labels.
  14. If your labels are overlapping, expand the Label Settings section, and toggle the Angle up or down (90 being vertical). 
  15. Depending on which rows are displayed, you may need to open the Worksheet rows section and change the First row and Last row values.

 

Follow these steps to create a bar chart:

  1. Click the Home | New Graph | Bar | Vertical Category Bar Chart (Grapher 12 bar chart category) command.
  2. Select the data file and click Open
  3. The default graph is created with the category labels automatically displayed.

 

Updated February 15, 2019

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.