If you selected a column that contained letters or symbols, such as backslashes and hyphens, Grapher cannot create a plot.
If the column contains numbers, but the plot is showing zero data points, look at the data in the worksheet. Normally, if the column is right justified the column contains numbers. If the column is left justified the column is formatted as text.
One common example of this is numbers stored as text. In Excel, when a number is stored as text, there is a small green triangle in the upper left corner of the cell. When you click on the cell, a ! box appears. Click on the box and select Convert to Number to convert the text to a number. Save the Excel file and click the Graph Tools | Worksheet | Reload command to reload the saved worksheet in Grapher.
This example displays the green triangles on all of the
cells in Column C. The top cell is selected, displaying the ! box.
If you would prefer, you can use Grapher's worksheet to correct the numbers instead of Excel. In Grapher, when numbers are stored as text, the values will align with the left side of the cell, rather than the right.
Open the worksheet in Grapher by selecting the plot layer in the Object Manager, then clicking Graph Tools | Worksheet | Display.
Highlight the entire column and click the Data Tools | Data | Text to Number command. Save the file and the graph will automatically update.
Updated September 21, 2017