Illustrator :: Copy Excel Chart To CS6
Oct 6, 2012
Copying an excel chart (2010 and/or 2013, Windows 7 Ultimate) to Illustrator CS6 works okay if line chart lines are solid... but if they are dotted, then in Excel 2010, the dotted line becomes jumbled, and in Excel 2013, the dotted line converts to a solid line... is the only solution to this to save the excel chart as a pdf, or is there another workaround?
Essentially, I am creating a chart in excel and adding a few notations and graphic elements in illustrator for professional publishing..
View 5 Replies
ADVERTISEMENT
Dec 20, 2012
I have some trouble with copy/paste charts from Excel 2010 into Illustrator CS5. I can move things around, but I can not change the colours in Illustrator. The chart is shown as a picture graphic, not a vector in Illustrator. Also when I save the Excel chart in a PDF and try to open it in Illustrator CS5 it is still a picture, not a vector graphic. Where is the bug? (I am using Windows 7.)
View 8 Replies
View Related
Feb 4, 2014
When I copied and pasted charts from excel, the lines are all doubled. This is the first time I got this. I could not figure out what is the difference between these double lines and the regular lines. Any clues how to change the lines to regular ones. I am using AI CC.
There is no difference in Excel.
View 5 Replies
View Related
Feb 6, 2014
I have an MS Word 2011 document with an Excel pie chart embedded.Double-clicking the pie chart will open it in Excel 2011.Copying/pasting the chart into Illustrator CS6 results in an uneditable bit image.
Previously, with Word 2008 and Illustrator CS2, this worked perfectly. Mind you, I had tons of excess empty paths and such to scrape out, but still, after a couple of minutes' scraping, I had an editable .ai file ready to be cleaned up, captions typeset, and colors edited for export to .eps and placement in InDesign
In fact, right now I've had to jump over to my old iBook G4 to open my old copies of Word 2008 and Illustrator CS2 in order to do this so I can get this job out the door.Is there any way at all that I can get an Excel 2011 pie chart into Illustrator CS6 as a vector image?
I've tried the shift-click on "Copy Picture" method, but the pie chart still appears as a bit image, and the text is turned to gibberish. Saving the chart as a pdf returns the same results.
At this point in the project, asking for the raw data set and regenerating the pies in Illustrator isn't an option -- and besides, I've had to do that before. Oh, the pain.
View 2 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
Nov 6, 2013
I' m importing Excel 2008 excel pie charts to illustrator CS5. I am cutting and pasting content between the applications to import. When importing a pie chart - the chart imports OK, but the pie elements import as low resiolution non-vector elements. Is there a way to import as 100% vector elements? Note - all other chart types - bar graphs etc import fine!.
View 5 Replies
View Related
Sep 11, 2012
The calibri font used for graphs in Excel are not recognized when the graphs are copied into Adobe Illustrator. Other than changing the font to arial or another font. I upgraded from CS4 to CS6 on my mac and I still get the same error, "An unknown shading type was encountered," and the letters in the chart get substituted with jumbled symbols. I've tried copy the chart directly from excel to illustrator as well as saving it as a pdf or postcript file and then opening in illustrator. But neither approach works.
A friend managed to open the chart in Illustrator (CS5 on a mac) which gave the prompt that it cannot read the font and that it will display it as outlines. This worked and the text was displayed properly. But for some reason I never received this promopt whether using illustrator from CS4 or CS6.
View 7 Replies
View Related
Nov 24, 2004
I cut and pasted a pie chart from MS Excel into PS, but when it prints, the imagery looks very low res, with jagged lines and text. Is there anything I can do differently, or is this a limitation due to Excel?
View 9 Replies
View Related
Feb 10, 2012
If I was to make a chart in excel or word can I insert this into autoCAD and have it so I can adjust this in CAD?
View 3 Replies
View Related
Nov 29, 2010
I have an embeded excel chart on my drawing called CLASS 125 Single Disc.xls. I want to switch this chart with another one known as CLASS 150 Single Disc.xls. How do I do this? I am using Autodesk Inventor 2011.
View 9 Replies
View Related
Mar 15, 2013
How do you ungroup or expand a pie chart in Adobe Illustrator CS6? This functionality seems to have been removed. Say I'd like to remove the legend: before, I could ungroup the chart, release its link to the data, and then delete the legend with my white mouse. Object > Expand no longer works either.
View 6 Replies
View Related
Oct 16, 2012
I use minus front all the time... well, I'm trying to make a pie chart with just the outside (see example). The logical way to do this to me is the make the pie chart, put an ellipse over everything and "minus front" it using the pathfinder tool. Well, I did this, and even though "minus front" is an available option--I can even click it--nothing happens when I click it. Even when I isolate each wedge of the pie chart, I cannot get any part of it to clip using "minus front."
View 9 Replies
View Related
Dec 18, 2013
What is procedure to create a legislative seating chart with illustrator.
Examples of such charts are as follows: [URL] ....
View 33 Replies
View Related
Oct 13, 2009
we have a website concept in Illustrator CS3, with named swatches for all colors. I'm wondering if there is an easy or 'semi-automated' way to generate a chart of the swatches we are using, showing there hex values?
I know I could draw out a bunch of boxes, fill them with the swatch colors, and manually look up and type in the hex values for each. But this would take a LONG time, as there are a number of color variations.
View 15 Replies
View Related
Dec 9, 2013
I want to create a creative graphic chart in Illustrator and place it into Word. the catch is that the client -- who doesn't use Illustrator -- wants to update it later. Is that a possibility? If not directly in Illustrator is there another app which would would play nicely with Word?
View 6 Replies
View Related
May 7, 2013
Is there a way to make a trend line with the chart tools in AI? Specifically, a polynomial trendline. I am so disappointed with the apparent limitations of the chart tools available.
View 1 Replies
View Related
Oct 29, 2012
I am working on a project which up until recently used Excel VBA and AutoCAD. To the point, one of the important things this process did was grab a range of cells in the Excel file and copy them to the clipboard. This range of cells was a nicely formatted table with borders, cell filled colors, etc... and the VBA code would copy it to the clipboard before laumching AutoCAD. Once AutoCAD was opened a LISP program would automatically paste this into the model space. It made a lovely OLE object in AutoCAD with crisp, clear appearance.
We are now trying to do away with the VBA part in favor of .NET. I am really at a loss to explain why the code I used before will not work, nor will anything else I try:
VBA CODE
Sheets("Sheet2").SelectRange("B1:K93").Copy
VB.NET CODE
vExcelRange1 - vExcelSheet2.Range("B1:K93")vExcelRange1.Copy()
The .NET code is not working at al.
View 1 Replies
View Related
Feb 5, 2014
Can you put line break in text in the data box when creating a chart.
i.e. if you have a bar chart with text underneath each bar, can you break it when you’re entering it instead of manually afterwards
View 1 Replies
View Related
Jun 18, 2013
We recently built our new company website which we're happy enough with. However one element we tried to capture was an interactive donught shaped pie chart, using javascript to click on each seperate section.
The end result can be viewed at URL....
You'll notice imemdiately that the part that's a little off is the text which sits in each section. IS there an easier way to combine the graphic, text and javascript to achieve the effect we're looking for?
View 6 Replies
View Related
Nov 14, 2013
I know we all feel the difficulty in how ancient the graph / table tool in Illustrator is.
But, is there a way to display Data Labels on the front of my stacked bar chart?
See attached image - this is what I want to achieve.
View 2 Replies
View Related
Jul 17, 2012
I am working on a scatter chart in Illustrator. We would like to use circles instead of the default square. I have figured out how to create and use a custom graphic for this. However, no matter what size circle I create, it seems to default back to the size of what the square was.
Is there any way to customize the size of the graphic objects used in the scatter chart?
View 3 Replies
View Related
Jul 9, 2012
I have a table in Excel (well several tables actually) that I want to copy the contents from and insert into an AutoCad table. I don't want it as an OLE object (as I need to be able to edit it in AutoCad later if needed) and I don't want it as a datalink either, so what is the best way to do this?
I was trying to just copy the cells although kept getting all cells ending up in each row/column. I believe it is possible somehow as I am sure I have done it multiple times before although can't work out how to do it now.
View 5 Replies
View Related
Jan 25, 2012
We have a Visual Basic Script that creates pie charts using Adobe Illustrator along with an internally created app called Chart Generator. An xml file that contains a markup for a set of pie charts is imported into Chart generator and by using Illustrator it generates all of the pie charts and saves them as individual eps files.
It was recently discovered that not all of the pie slices are proportioning correctly. In some cases a slice that is 10% of the pie appears larger than a slice that is 13% of the pie. We can’t determine a pattern that might be causing this issue. We think that the problem is in the Visual Basic coding.
View 3 Replies
View Related
Jul 19, 2013
I want to copy a value/text in cells from excel and paste it in specific mtxt that has been made in existing .DWG file.
I have done it by copy and paste, but it doesn't work effectively since there's too many cells to be pasted.
One of my cells entry which should be copy is in D5 and the coordinate of mtxt in autocad is (17,46 15,03 0,000) both of those file is located in same folder
View 1 Replies
View Related
Oct 22, 2013
This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this. I made a point table from a point group. Quick and sweet.
But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLE EXPORT but that's only for regular tables.
View 3 Replies
View Related
Aug 31, 2012
I am attempting to copy and paste a part of a drawing from AutoCAD 2011 into ms, Excel or Word. I am able to copy within a vport so my whole screen is not copied. My problem is only 2D objects show up when I paste. I tried different visual styles and colors but still cant get my solid objects to appear.
View 7 Replies
View Related
May 12, 2012
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
View 1 Replies
View Related
Nov 28, 2011
For some time I was using CorelDraw 12 with Windows XP and Excel 2007.I normally make some tables in Excel which I copy and paste into Corel using "Paste special"/Picture/Enhanced Metafile. In Windows XP there was no problem. Since I switched to Windows 7, I have the following problems:
- The font Wingdings 3 comes out as Arial.
- The second problem is a very strange thing: Some characters, such as ,-"; , always at the END of the line, just dissapear. It happens sometimes, not always, and I can't see absolutely no logic in it: I copy the same thing, paste it several times, and sometimes the comma comes out, sometimes not. I remember that this happened to me ONCE, long time ago, when I was still using XP, but then I restarted Corel and it stopped making problems. But now, with Windows 7, it happens almost all the time. I tried it on a few different PCs and I even tried it with Corel X4. Always the same problem.
View 2 Replies
View Related
Nov 5, 2013
I'm wanting to know if there is a way to Copy a selected area from Excel and Paste into Autocad and have it as lines and text objects?
Before everyone is entering the information in RED multiple times, once in excel and again in our cad file.
I don't want a data link because we are sending, only, cad files to our customers.
View 6 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
Jul 29, 2010
I have just upgraded from CS3 to CS5 and I'm running into a major issue. When I used to copy charts from Excel into Illustrator CS3 it would paste in as vector artwork, but now with CS5 it pastes in as a jpeg image.
I'd like the excel charts to paste in as they used to with CS3 as vector artwork with paths, strokes and text.
View 23 Replies
View Related
