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. 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. Click the File | Open command and open the file in Grapher's worksheet. Highlight the entire column and click the Data Tools | Data | Text to Number command. Save the file and the graph will automatically update.
Updated December 07, 2017