AppleScript numbers charts

Can you post a screenshot of your chart where you have clicked on it and Edit Data References? Also, perhaps, your AppleScript?

For example, here is a screenshot from the 'Charting Basics' template at File > New in your menu:

Note that the chart there is set up to automatically accommodate new rows in the data table.

That works fine with a simple AppleScript like this:

tell front document of application "Numbers"
	tell active sheet
		tell table 1 to set newRow to add row below last row
		tell newRow
			set value of cell 1 to 100
			set value of cell 2 to 80
		end tell
	end tell
end tell

Giving this result (which includes the new data point):

If you substitute dates into the first column in the table you should get a similar result. Note that although this is 2D Scatter plot you can easily add connecting lines between the data points if you want, so it looks something like this:

The AppleScript I used here was the same as above except that I used the line

			set value of cell 1 to "2020-01-11"

SG

I got the expected result here after running the script:

Before inserting a chart did you first select ALL the cells (A1:B2) in the table? That way, when you add rows to the table (either manually or via script) the chart will reference the entire columns including the new rows.

BTW, if your dates are always evenly spaced then you can use a "category" chart (2D Line) like the one in your last post. If your dates are unevenly spaced, though, you might consider using a 2D Scatter instead (as in the 'Charting Basics' template in the screenshot of my previous post). If you decide on a 2D Scatter then you need to make sure the first column is NOT a Header Column.

SG

Hi Jon,

I'm assuming the script is working properly, and is not the issue here.

Numbers charts take their data from a specified set of cells. To get the new data onto the chart, you need to expand that range to include the cells containing the new data cells.

You can avoid the need to change the range every time you enter a new date-number pair by including several extra and empty) rows.

The chart will expand to include these data points, but won't show any values until there is data entered in a row.

BTW: A "line chart" is a Category chart. Each entered date is treated as a Category, not as a number or quasi-numeric value.

Data for March 1, March 2, March 7, March 9 and March 10 will be evenly spaced. If the time between samples is significant, consider using an XY scatter chart, with dates on the x axis and number values on the Y axis, and using straight line connections between data points. The X location of the data points will then be spaced according to the number of days between each entry.using the list above, the left-right spacing would look like this (Ignore the date labels, as Numbers would use calculated dates evenly spread in time and evenly spaced along the axis):

    x         x                                                     x                     x           x

Mar 1, Mar 2,                                            Mar 7,             Mar 9, Mar 10

And the slope of the lines connecting those data points would be a more precise representation of 'change over time.

Regards,

Barry