import chart data from Excel or CSV
Need to be able to import data from an Excel (or at least a CSV) file, to create chart with Charting tool. Rather antiquated to have to copy/paste to get data for a chart. (In more than 30 years of using AI, I've NEVER been given a data file in TXT format--the only option currently available to import graph data.)
-
Micle John commented
I know how to dump data from an excel file to Adobe Illustrator dielines for printing labels.
-
Anonymous commented
Check out Datylon Graph for Illustrator extension. Maybe this solves the data importing issues you are facing?(and maybe even some more!)
https://www.datylon.com/graph -
Richard de Garis commented
Update charts as source data changes or is amended. In the case of Excel the link would replicate how InDesign does it, but additionally allow the import of a range that is too big - empty cells are ignored. This would allow for appended data, in the case of a time series.
-
Richard commented
From Excel, do File > Save As unicode text file. WIth a .csv, change the file extension to .txt. They are the same thing.