iworkkeynotemacosnumberspages
I have the 2015 versions of Pages, Numbers, and Keynote on Yosemite.
I created a chart in numbers and then copied it to Pages or Keynote.
I then want to be able to change the data in Numbers and see the chart updated in Pages or Keyonte. However, I don't see an option to "refresh".
Is there a way to dynamically link Numbers to Pages or Keynote?
I have had the best luck keeping the data in Numbers and only pasting tables and graphs into Pages. But that is because I like the added tools in Numbers and not that I've had any issues pasting back or forth.
I've done a few tests and can't replicate your issue on '09 versions of both iWork programs. Have you experimented pasting the data from pages to numbers as values (or paste and match style)? It is a long shot, but the two things that come to mind is pasting into a new spreadsheet (in case the one you are using has some sort of issue) or pasting data that is somehow formatted to cause an obscure problem.
As far as I know there is no way to make the desired changes all at once, but there is a way that you can make things significantly faster than creating a brand new chart.
As it appears you've already done, copy and paste the chart into your Numbers worksheet. Depending on the chart you've created, select an individual line, bar, pie segment etc. and open the chart pane in the inspector. Here's a screenshot of what that looks like (with "Example 2" being the copied and pasted chart):
As you can see, in the field labeled "Data," Table 1 is referenced. This source can easily be changed to a different table. Just delete the listed source and select the new source of data from your worksheet (you don't have to type in the source). Depending on your chart you may also want to change the data source for the x-axis labels. This is also controlled by the inspector. That can be changed here:
While you'll have to change the data source for each line of the chart, it's certainly faster than creating a whole new chart and having to format it the way you'd like.
Best Answer
Not yet. You can provide feedback to Apple here:
However, a month after this question was asked, Sal Soghoian - then the Product Manager for Automation Technologies at Apple got on stage to demonstrate how to automate placement of a numbers chart inside a keynote presentation. This should be easy to automate following the video and slides.