Simple enough to test, make a chart with or without imported data.
Place in in ID
Now update the data in either excel and or Illustrator.
save the Illustrator file.
Open the ID file does it ask i you want to update the modified link?
I would assume yes.
Sarah--that does seem to answer my question I think...unfortunately not the answer I want.
Wade--I've never imported excel into Illustrator and I'm clearly doing something wrong so I can't even make it through the first step sadly. I also admit that I'm so swamped that it was quicker for me to ask than to try. (shame on me!) and also sadly, I didn't even think about testing (another shame on me!)...probably due to being swamped.
What is the trick to importing? I put it into a text document like it said to do. Any ideas other than that?
Tab or comma delineated?
I know I did it how they said in the help section or on adobe live docs -- I think tab. The one thing I thought was quite odd is that it said not to use commas (like in 736,000...just leave as 736000) and there weren't any in the excel sheet, but there were when it was imported into Illustrator. I did then take them out in the data box. I got an error several times and I think I was able to maneuver it enough to not get an error, but it still wasn't correct. It put quotes around everything but the year (where the quotes should have been).
I think maybe it's just easier to type it in. I don't know how the excel sheet should be formatted/data should be entered. Another person puts all the data together (she analyzes it) and I'm not at all in charge of it. I can at least copy and paste, so I guess I'll just do that. To create a new spreadsheet for every single one would take forever I think (unless I'm missing something).
If you have a trick and know what I'm doing wrong, please let me know.