Illustrator :: Is It Possible To Link Excel Data To Graph
May 14, 2013
I'm laying out a report with many graphs of similar styling, the client is to provide an Excel doc with the figures and I need to redraw them as graphs.Is it possible to design the graph style in Illustrator, import the data from the spreadsheet to the graph and then place the graph(s) into InDesign. Essentially, this is what I'd like to achieve:
1) Style/design a graph in Illustrator
2) Import spreadsheet data into Illustrator graph (a step I'm also haveing problem with - is it possible to import an entire Excel doc or do you have to copy and paste each cell individually)
3) Import Illustrator graph into Indesign
4) If original data in Excel is changed/updated and the document is saved, data will update in Illstrator and therefore in InDesign.
View 4 Replies
ADVERTISEMENT
Jun 25, 2013
When I insert new data on an existing graph (for example, just adding a new year of data) and press insert, it just deletes the graph entirely. My only option is to recreate the entire graph which is frustrating because I lose its format and colors.
View 4 Replies
View Related
Dec 26, 2011
I'm messing around with tables and data links, practicing. I copied a range of cells in Excel, and did paste special to create a linked table.
Now I can delete the table object, but I cannot delete the link, cannot detach it.
When in Data Manager if I right click on the data link and click delete I get the error message "The data link is being used and cannot be deleted".
I have tried detaching, and the detach does not seem to take.
Now also, the table will not update from the source xls.
Win XP, AcadLT 2011, Office 2010. Using compatible setting for saving spreadsheet, for Office 2007 (not xlsx).
If I create a linked table by starting with the Table icon, choose "from a data link", choose the excel spreadsheet, etc., then I am able to later update the table from the spreadsheet, detach, delete the link, etc. But I can only delete the link if the table is not selected when I open the Data Link Manager.
But the one that was created following the directions from the Autocad video, with the copy, paste special, that link will not detach nor delete.
View 5 Replies
View Related
Nov 1, 2012
When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
View 2 Replies
View Related
Dec 23, 2013
I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
View 6 Replies
View Related
Jul 24, 2013
I want to link Microsoft Excel data with AutoCAD drawing (like dimension or values). When I made some changes in Excel data, value in AutoCAD drawing can be changes automatically.
View 1 Replies
View Related
Apr 26, 2011
we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies
View Related
Mar 24, 2011
As title says, I create a new Excel Data Link using "Data Link Manager" but it takes forever! If so, how can I get rid of waiting long time when creating/editing a Data Link?
View 0 Replies
View Related
Feb 1, 2013
I'm inserting a data link from excel into my CAD drawing and every time I try to select the table it brings in, the corner "grips" the green plus signs, are so huge they are bigger than my sheet and I can't see anything in the table. Any way to shrink them to a rational size?
View 2 Replies
View Related
Feb 1, 2013
I am trying to modify a bar graph that I have imported as a pdf from excel, and am having some trouble with customizing the color fill on the bars of the bar graph. When I select the object/bar and then fill with a different color, I see no change. However the menu shows the new color I selected for that particular object. Is there something weird about the type of object that the bar is when it is imported from excel?
OK I figured out that for some reason the bars on the bar graph are imported as clipping masks - very weird, you need to release the clipping mask, deselect the bar, select and delete the background shading, then fill the bar (which was previously the mask, I believe?) Why excel exports like this?
I notice something similar with the imported text labels associated with the same graph. When I select the text and change the font size, for some strange reason it can size up (say, from 10pt to 12pt) but not down (day, from 10pt to 8pt) It seems weird when I try to edit it at all really, as if the element was not a text element, is there some way to convert it to a text object? Ok this is working properly now, don't know why it was wonky before.
I am using CS5 with a Mac running 10.7.5
Also I am using excel for mac 2011
View 2 Replies
View Related
May 5, 2011
I struggled for a while this morning with trying to data link to a large door schedule in Excel. After several failures, I searched online for answers, and read in another forum that AutoCAD won't data link to more than 2000 cells.
My door schedule is about 2050 cells now, and will be about 4000 when done. I defined a set of about 1,000 cells in the Excel spreadsheet, and AutoCAD linked to it no problem. So, I tend to believe the poster who stated the 2000 cell limit, but I can't find this.
View 1 Replies
View Related
Sep 18, 2012
I have an issue between XP 32 bit ACAD 2011 workstations and Windows 7 64 bit ACAD 2011 workstations...
1 - A Windows 7 user does a Paste Special>Paste Link>Microsoft Excel to insertembed a portion of an Excel worksheet into the DWG.
2 - various win7 and XP users make changes to the Excel worksheet directly in Excel
3 - Win7 users open the DWG to see the correct and updated Excel data in the DWG
4 - XP users open the same DWG to see OLD data from a previous save and not the correct updated data on the linked worksheet
5 - XP users directly open the Excel file in Excel and are able to view the correct updated data BUT NOT IN THE DWG
6 - XP users see old incorrect excel worksheet data in the DWG. Win7 users see the correct data in the DWG.
View 5 Replies
View Related
Apr 16, 2013
The company I currently work for imports excel data via the paste special / link method. It works fine, however when i open obviously or plot through sheet set manager specifically and someone is in the excel file i get the read only message and have to click the box in excel to either read only or notify. How can i run plots and not have to check that box?
View 2 Replies
View Related
Jan 20, 2012
Where I can find the button to add data labels to a column graph?
These are the numbers/percentages that appear at the top of the column once it's been generated so you can see that is was say 50% or 60%.
View 9 Replies
View Related
Feb 20, 2014
I create pie graphs in illustrator for a financial sevices group. Every month when I update the data the format and colour of the graph distorts. I am spending too much time manually fixing the graphs.
View 3 Replies
View Related
Jun 6, 2012
How to get data values to display inside the columns on a column graph?
View 2 Replies
View Related
Jan 15, 2014
In a new Illustrator file, I select "Object...Graph...Graph Type" and make sure I have pie graph selected. Then I draw the circle I want to be a pie graph, make sure it's selected and choose "Object...Graph...Data" which opens the graph data entry "spreadsheet" but the text box and buttons on the top are greyed out and there are no visible cells. If I move the pointer around inside the window, it does become the "row/column" resize pointer as if there are cells present but disabled.
View 1 Replies
View Related
Sep 4, 2012
I need to make some graphs that are linked to a series of data through XML files (originally Excel) and create an indvidual document for each data set. They will be used for the web and print.
View 2 Replies
View Related
May 20, 2013
the rows/cells disappeared for my data in a bar chart in Illustrator CS5.5.The first number shows up but then I have to keep hitting tab but they are not divided into visible cells any longer.I usually see rows and columns like in Excel.
View 2 Replies
View Related
May 30, 2013
Illustrator can make graphs with lines and bars / columns, for example from the docs: [URL] .....
However, when I create a graph like this, I seem to lose the ability to manually set the value axis using "override calculated values".
To reproduce this problem: Create a graph like the example, with bars and an axis on the left, lines and an axis on the right. Unlike the example, don't fix the numbers so the lines match up neatly - have one side go up to just under 20, one up to just under 250, so there are mismatched markers and numbers of divisions on each side.Try to make the markers and numbers of divisions match up, so the side that goes up to 20 actually goes up to 25 and has the same number of divisions as the other side.Everything I've tried doesn't work:
If I select the whole graph and go to 'Graph Type', I can't set Value Axis options. In earlier versions it's greyed out, in CS6 I can access it but clicking 'Okay' does nothing.If I select the whole graph and chose one graph type, I can set the Value Axis options, but that selected graph type then applies to the whole chart,If I use the Group Selection tool to select one of the series, and open 'Graph Type' options, changing the Value Axis options has no effectIf I use the Group Selection tool to select all series that share an axis and open 'Graph Type' options, changing the Value Axis options still has no effectIf I use the Group Selection tool to select the axis ticks group itself, or the axis line and axis ticks groups themselves, or the axis labels, axis line and axis ticks, or the axis labels, axis line, axis ticks and associated data series, etc, changing the Value Axis options also has no effect
It seems like this feature is broken and it seems like the example in the manual was carefully chosen to use a rare combination of numbers where it would actually look right.
View 1 Replies
View Related
Feb 4, 2014
I have a column graph. I want the data values to display in the columns. How do I do that? Here's what I have now:
I want the values 270018, 283148, etc. to display in the graph. Is that possible?
View 15 Replies
View Related
Oct 9, 2012
I'm totally new to Illustrator and want to use the line graph tool to insert a graph that passes through 0,0 and runs to 24,24. I want the x and y axes to meet at the origin. As it isn't working as you can see. I've used 0, 0 and 24, 24 as my data points. Is there any way I can change how this is presented so it's clear that it's at the origin?
I'm using CS6, if that matters.
View 9 Replies
View Related
Oct 30, 2008
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
View 8 Replies
View Related
May 6, 2012
Can you access graph data through the scripting DOM?
View 3 Replies
View Related
Apr 4, 2013
I was wondering if there was a way to import excel datat into illustrator, then it populates a vector pie or bar chart for me?
[URL]
View 1 Replies
View Related
Aug 25, 2013
On my Mac OS X (2010), running Excel 2011 and Adobe CS6, I'm having major issues with the points in a scatter plot not rendering as vectors once moved to an Adobe program. The entire plot will transfer as a vector, except the data points themselves! Oddly, even the shapes in the legend are vectors! When I save a plot from a powerpoint presentation as a pdf, the data points look pixelated in the pdf. When I copy paste the plot into illustrator, same thing. It is totally infuriating.
View 5 Replies
View Related
Mar 16, 2012
I was wondering if there was a way to extract data from Excel to be used in Illustrator. I know there is an option of variables and xml, and I don't want that. I've seen and tried out how to read illustrator and write to excel, and I get that. What I would like to do is pretty much the opposite:
1.Pre-fill in an Excel file(.xls,.csv, doesn't matter) with data such as a filename in column 1 and (Replacement Text) in column 2 and close manually.
2. Run script(VBSCRIPT,Javascript, doesn't matter)
3.For each column in Excel file where cell in first column is not empty, open Illustrator Template with placeholder of "DWG" textframe and replace the frame titled "DWG" with Replacement text from Excel in Column2.
4, Save each to a PDF file and name file with text from Excel Column1(Filename)
In a nutshell, there will be a single illustrator template with a premade textFrame with a name of "DWG". Excel will contain two columns, one for the filename to be named and one for the relative text to replace with the placeholder in AI.
View 17 Replies
View Related
Oct 27, 2013
I want to send the contents of A1 to an Illustrator document at 135, 172 and B1 to 135,190, same with A2/B2 will be at different coordinates as will A3/B3 and so on... I want to do this 6 times and save the document as a PDF. Then, it should clear and do it again. The columns will ALWAYS be A and B.
View 5 Replies
View Related
Oct 27, 2013
Problem:
How to read real number data from selected columns in an Excel spreadsheet into an illustrator javascript array variable, so that then I can use this information to construct an illustrator polygon.
Further information:
I am new to javascript (and not much of a programmer in the best case, but do have some basic knowledge using ancient languages like FORTRAN 88). I am sure I am just missing an important step here despite all morning browsing with Google for answers (something to do with variable definition I assume?). I have some survey data defining the outline of features in map view listed in a string of point (x,y) values in adjacent columns in excel (these x,y point values calculated from GPS data using a commercial program to converted 3D position to a 2D x,y by geoid projection, and then in excel to re-scale point locations to illustrator’s artboard). What I am trying to do is select columns of x,y value pairs in an excel spreadsheet, copy these values to the clipboard, and then develop an IA JavaScript to draw a polygon through the specified set of x,y points. It seems easy enough to script illustrator to draw the polygon once I get the values from the clipboard are in a javascript array (lots a good tips here [URL] ....), but pulling in the clipboard data seems to be beyond me. I have tried populating a defined array with various combinations of array declarations and app.paste(); or windows.clipboardData.getData('text/plain'); with no satisfaction. I then had the idea to try to pull in the clipboard to one long continuous string, place that in a text box (see see its structure), andthen read and split up the text in a loop to populate the JavaScript array…but that deposited a complex illustrator table object into my text box, and several attempts to force the clipboard to paste text did not work (again probably having problems understanding variable type declaration).
I would be happy to find any method of scripting the pull of the selected on an excel spreadsheet for use in an Illustrator script…so if I am making this all harder than it needs, be I would be grateful to know that also!
View 4 Replies
View Related
Mar 28, 2013
I have a drawing with Objects that have both Object Data and Linked data in an Access database. I need to get information from the linked table to a new linked table for each object.
I have thought that if I get the necessary information from the Linked table record to the object data for each object, I could then convert the Object data to a new link and am looking for a way to copy the data from a field in the Linked Table to the object data. There is at least one field common to both the OD and Linked Table record.
Is there any automated way to transfer this data?
View 5 Replies
View Related
Jun 25, 2013
In my company, they have just upgraded the old version of Autocad LT 2004 to the new 2013 and we have created menu to make our job easy. I have try to transfer the menu file .mnc to 2013 but it's not working or I don't do it the right way.
View 4 Replies
View Related
