Is there a way to input variable excel data into multiple column graphs in Illustrator? So, for example, I need 100 different graphs, like the one shown below, that have the same graph style and the vertical axis (0-100).
The variable data that needs to change based on the excel input are:
- 2 blue and green bar columns (%Percent1 & %Percent2)
- the horizontal axis (Year1 & Year2)
I want to avoid manually copying and pasting 100 individual graphs to then manually change the 100 blue and green columns and horizontal axis?
I'm also having trouble figuring out how to put a % to the end of the totals in both column designs. I currently have them set as "%00" to capture the data input as it changes, but when I try to add a % to the end of the text it no longer follows the data input.