I've seen several posts highlighting the ability to link keynote charts to numbers tables.
Does anyone know if you can also link keynote interactive bar charts to numbers tables, so when the data updates in the numbers table, it will also update in the keynote interactive bar chart.
If so, where's the best place to hire an individual apt enough at Apple Script to do it?
Thank you in advance.
MacBook Pro 13″, macOS 10.13
Since Oct 2013, and thru current versions, one cannot link tables between Pages, Numbers, and Keynote. The AppleScript dictionary does not support this feature as the applications are not designed for this purpose.
One could link a Numbers table to Pages with Pages '09 v4.3 and Numbers '09 v2.3 but I do not recall any articles allowing one to link Numbers '09 v2.3 tables to Keynote '09 v5.3 tables. One can be lead astray by these old articles thinking that it applies to entirely different applications now.
Word, Excel, and Powerpoint do support linking of content between them.
Since Oct 2013, and thru current versions, one cannot link tables between Pages, Numbers, and Keynote. The AppleScript dictionary does not support this feature as the applications are not designed for this purpose.
One could link a Numbers table to Pages with Pages '09 v4.3 and Numbers '09 v2.3 but I do not recall any articles allowing one to link Numbers '09 v2.3 tables to Keynote '09 v5.3 tables. One can be lead astray by these old articles thinking that it applies to entirely different applications now.
Word, Excel, and Powerpoint do support linking of content between them.
Yes, and no.
While there is no direct interaction support (update a Numbers sheet and the values immediately populate in the Keynote presentation), there is still reasonable AppleScript support in both apps, to the point where it's possible to craft a script to read a cell value from Numbers and update a corresponding cell on a table in Keynote.
The tricky part is writing it in a flexible way that can work universally, that doesn't break when you reorder slides in Keynote, or
otherwise move things around.
The earlier-referenced thread does cover this, with a script that creates a new table on a Keynote slide based on an open Sheets document. Ultimately this is a good starting point, but it's not much more than a simple copy/paste of a table from Numbers. Creating a new table, though, will lose any formatting and styles, which is where an 'update' AppleScript could be beneficial. Not a trivial task, though.
See if this helps: Is it possible to link a chart in Keynote… - Apple Community
Agree on the AppleScript (or JXA) approach to "copy" table content from one application to the other. Also agree on the "tricky" part of implementing and supporting it on the OP end.
Saw that. Thank you. That's one of the posts I saw that highlighted the ability to use Apple Script to make the link. I'm now asking more specifically about linking an interactive bar chart to a numbers table AND more importantly how I would find someone who could do that for me.
Paid of course.
Using Apple Script to link Keynote charts to Numbers charts
