Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


automatic importing data for different graphs in Illustrator

New Here ,
Mar 04, 2021 Mar 04, 2021

Copy link to clipboard

Copied

I have a question. I would love to know if it's possible to have one data sheet with different kinds of data in exel linked to a one-page illustrator infographic? So by example; I made an infographic with data-graphs (circle, a column-graph etc.) those different graphs need different data. I only want one excel-sheet where all this data is gathered so if a client would wanted to update it (monthly) with new data, the graphs made in Illustrator automaticly update. So kind of like a hyperlink of some sort.

I know about variable data, but that way it is still a one way traffic and not one for different graphs on the same artboard.

Does anyone know how to do this sort of thing?

 

Thanks in advance.

TOPICS
Feature request, How to, Scripting, Tools

Views

112

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Adobe Community Professional , Mar 04, 2021 Mar 04, 2021
Variable data is only one-way in Illustrator is when looking to establish a 'live link', that is correct. Otherwise, variable data can do multiple graphs in the same document but you just have to make sure your individual graph states are in separate .csv (or csv or .txt if using the VariableImporter script). So if your issue is solved by some automatic process that takes customer data, puts it into individual CSVs and you have a constant 'main' data csv which does not change in regard to its va...

Likes

Translate

Translate
Adobe Community Professional ,
Mar 04, 2021 Mar 04, 2021

Copy link to clipboard

Copied

You can link variables to more than one graph on the artboard.

It doesn't work with Excel sheets directly though.

 

You could also give the VariableImporter script a try, it expands Illustrator's capabilities.

https://github.com/Silly-V/Adobe-Illustrator/blob/master/Variable%20Importer/VariableImporter.jsx

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 04, 2021 Mar 04, 2021

Copy link to clipboard

Copied

Variable data is only one-way in Illustrator is when looking to establish a 'live link', that is correct.

Otherwise, variable data can do multiple graphs in the same document but you just have to make sure your individual graph states are in separate .csv (or csv or .txt if using the VariableImporter script).

So if your issue is solved by some automatic process that takes customer data, puts it into individual CSVs and you have a constant 'main' data csv which does not change in regard to its variable names or amount of variables, then this can be a mechanical 'live link'. In such a setup various automation scripts would do this work every time you want to update the data and not go through a lot of manual clicking.

  1. Turn customer data sheet into separate .csv files for the graph variables in Illustrator.
  2. Have your Illustrator document already contain bound graphs to named variables, these are items in your 'main' data csv so for each graph you have a file path like an image path.
  3. Use a scripting command to import the same 'main' data csv that has all the items unchanged in it.
  4. When it imports, since the variables already are bound and nothing changed in your main csv (regarding variable names and quantities), it will just go through all the graphs and update the graph as it is referenced by file path like an image file.
  5. So now you should have all your graphs looking new.

 

The above process could be made into a one-click operation but still it's a very mechanical DIY-style 'weekend at Bernie's' 'live-link'. To go the next step it may be possible to automatically invoke this process when opening an Illustrator file. To do something when a document is being opened it may be possible to leverage CEP extensions as they are reportedly endowed in Illustrator with the ability to listen to an event which happens when a document is being opened.

If such an extension can indeed listen to this event (some Adobe apps have different support for such events), this process can be invoked when a document is opened by a user or by the application (opens multiple files, or file was double clicked from file system, or a script opened a file). However as this process may take a bit of time, I am not sure what will happen when multiple files are opened like this - but in any case you would want to verify the last time the user updated their sheet with the last import time so your process doesn't have to repeat work that will not change anything.

 

Another way could be using AutoHotKey on Windows or Keyboard Maestro on Mac to also listen in to Ctrl+O key combo while inside Illustrator. Theoretically this will help if you want your process to only work when a file is opened using Ctrl+O.

 

Also for inspiration, check out this link!
https://www.linkedin.com/pulse/illustrator-power-user-interviews-multiple-variable-graphs-hall/

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 12, 2021 Mar 12, 2021

Copy link to clipboard

Copied

LATEST

Thank you very much for your time and this usefull explanation. 

I'll do some experimenting 😉

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines