John Garrett shows how to add graph information to your csv file for later import into Adobe Illustrator. He explains how to format the graph data within the linked files, and the file format they must be saved with in order to import correctly, due to limitations of the Adobe Illustrator graph importer.
- [Voiceover] Entering graph data into your spreadsheet…is a similar process to adding in image data,…except instead of image files,…we have to add in separate spreadsheet files.…First, let's take a look at our column header in column E,…which is our graph column.…The variable name is preceded by a percent sign,…which tells the variable importer script that it should be…expecting separate spreadsheet files to import.…Just like our image variable's at sign,…the percent sign is only added here in the spreadsheet.…I'll switch over to Illustrator.…
In the Layers panel, we can confirm…that indeed the graph object on the Stats layer…reads hero_stats with no preceding percent sign.…Switching back to Excel,…there's nothing else remarkable about the graph header.…Unlike the at symbol for images,…the percent sign doesn't trigger…any formula issues in Excel,…so we don't need to worry about escaping the character…with an apostrophe as we showed in the last video.…That means we can move on to filling in our column…with the graph information we need here.…
Designer John Garrett appreciates the many different types of variables and their practical uses, including generating business cards and direct mailers. In this course, he explains how to use variable data including managing linked images, graphics, tables of data, and graphs. He covers the entire workflow, from setup to exporting dynamic batches.
- Setting up Illustrator files
- Using Appearances
- Setting up data sources
- Importing data
- Managing linked variables
- Binding and using prepend paths and presets
- Using the Variables panel
- Naming data sets
- Generating multiple versions with batch exporting
Skill Level Advanced
1. Exploring Variable Data
2. Setting up Illustrator Files
3. Setting up a CSV Document
4. Importing using Variable Importer Script
5. Working with the Variables Panel
6. Exporting and Reviewing
Creating a save action3m 25s
Next steps1m 12s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.