Can I plot data based on time in Grapher?

Yes, Grapher can create a graph with either axis based on time. The key is getting the worksheet in the correct format. Many programs create data files with time in one column, date in a another column, and the plotting value in the third column. If all of the times are from the same date, you can use the time column by itself to create a graph. If there are multiple days, the date and time need to be in the same column for the graph to appear correctly. In Excel, you can add the date and time columns using the following function:



Where cell A1 contains the date and cell B1 contains the time. After adding the columns together, format the new column as a recognized Date format. Copy/paste the equation for the entire column so all rows are displaying date and time. Save the worksheet as an XLS or XLSX file. This new column can be used to display your time plot in Grapher.

The X Axis is displaying the date time.


Updated July 7, 2016

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


Please sign in to leave a comment.