Automators 3: Sal Soghoian uses AppleScript to turn a Numbers Sheet into a Keynote Chart

Aug 03

Automators Artwork In the third episode of Automators we are joined by Sal Soghoian, AppleScript God, to learn about AppleScript and how to use it!

While David and I usually take it in turns to write up everything about the show and provide complete documentation, Sal's actually done that for this week:

The macOS Automation page for Automators

You can find the scripts, videos, and a complete breakdown of everything over at macOSautomation, along with all of Sal's other things.

In this show Sal gave us 3 AppleScripts. The first takes a whole table, and converts it into a bar chart in Keynote, the second takes a row or column and makes a pie chart, and the final one takes selected rows and turns them into a chart.

Q1 Q2 Q3 Q4
Widget A $1212 $1495 $1170 $1423
Widget B $1902 $2345 $1835 $2121
Widget C $2636 $3250 $2542 $3168

The brilliance of this, is the first script is just 17 lines - that's it!

Numbers table to Keynote Chart in images

You can listen to the episode over on Relay FM. And make sure to use the code in the show if you want to attend CMD-D Down Home Scripting Bootcamp!

automators applescript keynote numbers sal soghoian

Related Posts

Webmentions

Add a comment

Previous Post Next Post