Illustrator :: Copying Chart From Excel - Unknown Shading Type Was Encountered
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
ADVERTISEMENT
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
View Related
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
Jan 26, 2013
Heres all my system info.
Adobe Photoshop Version: 13.0 (13.0 20120315.r.428 2012/03/15:21:00:00) x64
Operating System: Windows 7 64-bit
Version: 6.1 Service Pack 1
System architecture: Intel CPU Family:6, Model:10, Stepping:7 with MMX, SSE Integer, SSE FP, SSE2, SSE3, SSE4.1, SSE4.2, HyperThreading
[code]...
View 6 Replies
View Related
Jan 15, 2013
I have an issue with copying cells containing text from Microsoft Excel 2011 for Mac and pasting them into Illustrator CS5. I select the whole cell(s) from Excel, open a blank Ai document and, without anything selected so the format is preserved, I paste the cells.
The issue comes with the resulting copy of the cells in Ai. The type which was bold in Excel is bold in Ai... but not really. Ai pastes the bolded text as not bold, but then makes a copy of that same text, puts a stroke on it, then places that over the regular text, so it looks bold. But now I have two copies of the same word, one regular and one with a stroke on it right on top of one another.
This normally wouldn't be an issue but I have to edit this info in Ai later - and there's a second problem. When I paste the bold text from Excel in Ai, the resulting word is broken up into individual text blocks for each letter. Instead of preserving the whole word as one editable text block, I now have to click on each letter to change it.
There is a catch 22 to these problems: These cells that I am copying from include bolded and regular text, and the regular text pasted into Ai without any problems (even the text blocks are preserved). So it's the bold text that is causing the problems
I have a feeling this has to do with how the individual cells are formated in Excel, but I have to copy data from many different cells made by many different people, so I am at a loss of what to do.
I have include a screen shot of what's going on with cells after I paste them in Ai. I have moved the oulined "5" up so you can see the regular "5" below it.
View 3 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
Jun 20, 2013
I have LT 2012. I use Excel 2010 into my drawings to set up tables. When I opened the drawing I've been working on, I had lost all of yesterday's data. Command History shows dozens of these notations, "AcDbLine(41859) XData Handle Unknown, Null" In Help it says you can no longer turn handles off, so it should be ON. How can I point the drawing to my Excel data?
View 2 Replies
View Related
Feb 15, 2014
I'm exporting photos from Lightroom 3 to be burned to a CD for a client, and only want to export one set of files. Which output sharpening setting should I use if the client does not know if they want the photos printed on Matte or Glossy paper, and indicated "probably both"? The photos will also be viewed on screen, but prints are the preferred end use.
View 4 Replies
View Related
Jul 23, 2010
I have a table in Auto cad ( 2008 ) that I would like to transfer to Excel, I have tried copying the table, and copying the cells, but no good.
View 5 Replies
View Related
Oct 19, 2009
I am new to VBA for Autocad and have basic knowledge of Autocad, but have experience with VBA with EXCEL. I am trying to search for text written on to a drawing that has been written as plain text. There is no table. I am writing code to open each drawing in the file as a for each next loop and then find text, then copy text to a table cell, in a table set up within the loop statement. Then I intend to transfer the data to Excel. When I copy the text into the cells of the table and transfer to Excel, the text does not transfer. Is there something I need to do to re-format the text copied straight from the drawing into the table cell. The drawngs have been produced by some external drafting service provider, most likely in India. The functionality of Autocad has not been used and therefore, there are no tables. The text titles, sub-titles etc... are just basically text with lines drawn around them, to simulate a table that looks like a table but are infact not.
My main problem is copying the plain text (titles, sub-titles, references etc...) into a table cell for export to Excel. Any knowledge of copying Autocad plain text to Autocad table cells
View 2 Replies
View Related
May 9, 2013
Using: Illustrator CS2 on Win XP Pro sp3
Experience - minimal (I come from using Xara and Inkscape).
My method of doing this type of art is mostly in Xara. I would creat block color shapes with decals and sticker, etc. and then use transparency gradients to create highlights and shadows. Here I was testing / getting use to the mesh tool and shaped the form of the car with color - rather then trasnparent highlights and shadows (top). But I now have to add stickers and decals to this car and tried to apply a clone of the hood mesh over the red stripes and it created a strang clipping error. You can see in the bottom screen cap that the sides and lower part of the red stripes disappeared, while the top remained untouched. Will I be able to use the mesh tool to create transparent highlights and shadows over the top of blocked coloe and the stickers, or will I have to manually match the shading on each sticker?
View 12 Replies
View Related
Nov 18, 2012
In the screen grab here, you can see that "errors" in gradient smoothness coincide with control points..or maybe between certain control points....is there a way to prevent this error from happening?
View 7 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
Jun 11, 2013
In the above image, certain paths have some kind of brush effect or shading effect (as evident in the path above). I'm wondering, how can I remove whatever effect this is from all paths in the above shape, I don't want to have it.
View 4 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
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
Jan 8, 2014
A few years ago I learned in school the usefullness of global color. I used it today and it was very usefull to quickly change the color of a lot of different objects at the same time.
HOWEVER; I remember they also tought me that it was also possible to change the brightness or shading or something inside one global color.
for example lets say I picked a red as a global color, and I have 10 objects all in that red. Then it should be possible to let 5 of those objects have a lighter version of that red color.
Then afterwards when I change my global color to green, all the objects change to green, and those 5 objects now have a lighter green color.
Am i remembering this correctly, and if so; how do I apply this? Because I cannot figure it out...
View 3 Replies
View Related
Dec 19, 2013
I need to shade a curved surface on a simple patent drawing and am restricted to using either a stipple or a simple straight line surface shading by US Patent Office guidelines. I'd like to use stipple but the only stipple I can find is a symbol for the spray tool which, when used, creates a spray pattern way beyond the drawing boundary which is not eraseable.
View 5 Replies
View Related
