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.
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.
Copy link to clipboard
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.
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!
Thank you very much for your time and this usefull explanation.
I'll do some experimenting 😉