Illustrator :: Why Do Graphs Pasted From Excel Lose Their Line Formatting
Mar 11, 2013
I have a detailed graph that is created in Excel that I want to paste into Illustrator so that I can save it as a high resolution TIFF file for submission to a journal.
In Excel the graph looks like this:
But when I select it (using Select Objects and then Copy OR Copy as picture) and paste it into Illustrator, it looks like this:
I have used different line formats in Excel for the different curves that are plotted and these obviously don't come through correctly when pasting into Illustrator. The lines are there but the scaling for the dashes or dots seems to be changed (increased). I'm good with Excel but a bit of an Illustrator newbie, why this is happening and can it be corrected.
I am on Win 7 64 bit system using Office 2010 and AI CS6
View 5 Replies
ADVERTISEMENT
Sep 29, 2011
I'm trying to import Excel charts (from Excel Office Home and Student 2010) into Autocad LT 2009. I've been doing this for years without a problem using Excel 2003 but now that I've upgraded to Excel 2010, I loose a lot of formatting (line weights are different, fonts are jumbled). how I can import with Excel 2010? BTW, I tried the trial of Autocad LT 2012 and still had the problem.
View 3 Replies
View Related
Oct 31, 2013
When text is pasted from one CS5 document into another and is inserted into the existing text in the destination doc, is comes in as a size different from either the source or distination size. Both docs are of the same resolution. The text being transferred is acquiring new formatting somehow. These are older docs, I don’t know what I might have done with/to them previously.
View 2 Replies
View Related
Jul 31, 2013
In a lab the students get this kind of graphs to later be processed in an axial system: a grayed pencil draw, very delicate, with all the imperfections in weight, intensity, etc.
We need to obtain an uniform line (a solid one, without gray variations, same weight, etc)
Autotrace seems the best tools although the results appear a little irregular. What could be the best approach as we have hundreds to process?
Beginning with the scanning (more resolution?) and processing firstly in Photoshop?
View 9 Replies
View Related
Apr 24, 2013
I'm trying to create a line graph in Illustrator CS5, with a data set that contains some numbers, but then has gaps before a final number at the end. The graph needs to show a general trend between the gaps.
Is there a way of forcing Illustrator to draw a line between those figures, as it's just leaving a gap in the graph at the moment.
View 4 Replies
View Related
Apr 12, 2013
I am using Corel Draw X5. When I paste an Excel graph into Corel the resolution looks terrible. I can paste this same graph into most other programs and it looks fine. No matter what I do and no matter which special paste command I use I am not happy with the resolution of the graph - you can actually see the pixels. When I convert to PDF you can still see the pixels.
View 5 Replies
View Related
Mar 7, 2012
I'm trying to convert Excel graphs into high resolution tiffs. I am saving the graph as an .eps file and opening it in Photoshop. This worked for a few graphs, then all of a sudden Photoshop started opening the .eps file such that it was shifted and only part of the image was showing up (the rest cannot be seen and is just cut off).
View 3 Replies
View Related
Nov 7, 2011
I HAVE PASTE EXCEL FILES ON MY DRAWINGS BY USING PASTE SPECIAL, AUTOCAD ENTITIES, AFTER THAT WHEN I SAVE MY FILES IT COMES LIKE THIS:
SAMPLE.dwg" has a command in progress.
Hit enter to cancel or [Retry]:
I ENTER IT EVEN RETRY IT BUT MY FILES STILL NOT SAVE.IS THERE'S A WAY TO SAVE MY FILES AFTER I PASTED EXCEL?
View 2 Replies
View Related
Sep 24, 2012
I have linked a table from excel into autocad 2012. I have selected "Start with excel formatting, do not update" in the datalink options. My problem is when I break the table the first table will keep my formatting changes - text height and alignment, but the following table breaks do not stay the same once I close and reopen the drawing
View 1 Replies
View Related
Feb 22, 2012
I created some tables in the attached AutoCAD Map 3D 2011 drawing by copying and pasting cells from an Excel 2007 workbook.
I have been able to update the tables in AutoCAD and print without any problems. However, when a second user opened the drawing, the table text was missing (the lines were present).
Note: We are saving our files in AutoCAD 2010 format for compatibility with some LT users.
View 2 Replies
View Related
Sep 9, 2011
I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.
After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.
PS: Using AutoCAD 2011
View 7 Replies
View Related
Apr 17, 2012
I've created a data link, linked to my autocad drawing, checked the box to keep excel formatting and update. Once i Import the table, the size of the table is NOTHING like what the size is in excel.
I have my page layout in excel to be 11 x 17 landscape. I have my table at about 9 1/4 x 15 landscape. Once I import it into autocad, it is now about 6 3/8 x 20 1/4. I don't know what i'm doing wrong but i need it to transfer just like it is in excel as far as the size of it.
View 2 Replies
View Related
Jan 17, 2013
I'm able to print pasted excel table with default colors ( ie: cell with text and fill with color background in autocad. By using Autocad 2013, with I can see the default colors when preview, but once I printed out to hard copy or PDF format, its only printed text but without any color background, I have try to print the pdf file by using DWG To PDF.pc3, Adobe PDF & CutePDF Writer, HP Design Jet T1120 plotter, all have the same result.
View 8 Replies
View Related
Nov 18, 2013
[URL]
Bring that back from the archives... because I am still very fond of redoing hundreds of cross sections because you're incable of redistributing the graphs when a sample line is added to a an existing group... and blow up all of the projections well done.... way to leave out a super critical dynamic component.
PPD E P I C F A I L
There is some unbelievable gaps in the software but how do you let this one go on for so long?
Dell Precision T3500 - Xenon W3550 @ 3.07 (4 core)
Ram @ 12Gb
64bit Win7 Pro
Samsung SSD
NVIDIA Quadro 2000 - Dual Monitors
Cat 6 network with GlobalScape Avail Agent - WAFS
Infrastructure Design Suite Premium and Civil 3D 2012
View 1 Replies
View Related
May 12, 2009
I have a scan of a pencil sketch as my background image. What I want to do is convert to colour image then, eventually, lose the pencil lines. For starters I would like to know how to flood fill an area with colour then get rid of the area's boundary line. I guess a valid solution might be along one of the following lines:
1. Flood fill, depositing the colour in one layer but using a boundary line in a different one.
2. Copy the sketch to another layer, fill the areas then somehow delete the lines.
3. Flood fill in one layer then copy the block of colour only, not the surrounding line, and paste into another layer. Any suggestions? As of a week ago I'd never used Photoshop so don't assume I know anything.
View 4 Replies
View Related
Jan 24, 2013
I can't open an illustration with two pie graphs in CS6. I am saving as CS6 format.I tried to recreate again and save under multiple file names and still none will open.
View 19 Replies
View Related
Mar 17, 2013
After selecting the graph, I then select data under Object>Graph>Data. The window comes up, but no data - to modify!
View 4 Replies
View Related
Jan 7, 2014
Mac, Illustrator CC.(Vent from CS 5 to CC). I am producing an annual report containing a lot of graphs using CC. Hoewever i stil have to use Indesign CS5 (InCopy later on).I have experieced for several times now that an error occurs after i place the charts in InDesign. As i try to open the charts from within InDesign, i get: Errormessage: "see Attached" - then it opens - completely empty.Afterwards trying to open from illustrator CC i get the same errrormessage "see Attached" - then it opens - completely empty.However i can open the graphs from illustrator CS5. But only 1 layer and all hidden layers thrown away.Have you experienced something linke this using CC - or do you know if the graph possibilities have changed in CC.
perhaps the files ar damaged in the moment i open from inside InDesign CS5?
View 4 Replies
View Related
Mar 1, 2013
I have created reports with infographics (bar charts/pie charts etc.) where the raw data and charts were created in Excel and then I copy it into Illustrator and tweak the design (color, text, etc) and then drop it into InDesign.
I am now in the process of creating several (30+) reports that will use the same design template from InDesign - but all of the garphics will be uniqe.
What is the best approach to create all of these graphs? Is there a script or macro that I can create and save when I tweak one graph, and then apply it to the subsequent graphs?
I know Illustrator has the graphing function but I havent had too much luck with and, and some of the graphs that I will create, such as donut graphs, cannot be created in Illustrator.
View 3 Replies
View Related
Sep 23, 2013
Any easy way to add the numbers/values into each bar in a bar graph and have them appear automatically when importing data from excel? I'm working w Illustrator CC.
View 1 Replies
View Related
Oct 4, 2013
I've been trying to use graph tool in Illustrator CS6 (I have Creative Cloud..) but having some issues when changing the design of columns. I'll create a design for a certain set of columns, but when I try to use the design in the graph itself they disappear completely. The data still shows in the data menu, but no bars! And its not on all the bars, usually just one set. I've tried reentering the data and also recreating the column design and nothing seems to be working..I keep having to restart graphs and having the same issue.
View 1 Replies
View Related
Mar 2, 2008
Doesn't seem to be possible. "Expand..." does absolutely nothing, and "Expand Appearance" is disabled.
View 5 Replies
View Related
Jul 16, 2008
How to transform the y-axis to a logarithmic scale when creating line-graphs in Illustrator?
View 3 Replies
View Related
Aug 28, 2013
I have a horizontal bar graphic and I want to make it have the same shape than a circular graphic that I have as background.
What I do first is to rotate the graph (after converting it in an image) to the right angle, depending on where it has to be positioned. After that, I use the Effect->Deform->Arc to make it fit in the same shape as the circular graph. But when I do those processes (in any order) I get a distorted image, with lines not describing concentric lines (not as radius, I mean).
I got the perfect shape working on a MAC, but now I am working on PC. How can I achieve the same?
I attach an image descrbing what I am telling.
View 8 Replies
View Related
Jan 9, 2014
I have several Freehand bar graphs and line graphs that I need to convert to Illustrator.So far, I have saved the files to Illustrator 7 and then opened them in Illustrator CS2.
But the numbers underlying the graphs don't seem to come through.How can I keep those numbers intact, bringing them in from Illustrator so that I can go back into them and update numbers to generate the bar graphs and line graphs in Illustrator?
View 3 Replies
View Related
Nov 6, 2012
We are introducing a new graph design, but has a problem with not being able to override the tick marks in the category axis in Illustrator CS5. A typical graph (line layout) can have 250 observations, and since we have the tick marks on full width, the graph gets "crowded" with black lines.
In the value axis there is possibilites for overriding the values, but not on the category axis.
Is there any way to script so that the tick marks in the category axis can be reduced/overrided to e.g. 1 in 20?
View 3 Replies
View Related
May 22, 2012
I'd like to create sheet notes with different line spacing and paragraph spacing in ACA 2013. When I change before/after Paragraph spacing settings in the Text Formatting window, I get a message reading "please provide a value within range of 1/4" and 4". I'd like to use 1/8" for the paragrpah spacing, which is the same size as the text.
View 1 Replies
View Related
Jan 29, 2014
when I export jpeg from Illustrator 5,I lose resolution. I am using windows 8 system.
View 1 Replies
View Related
Mar 7, 2014
I have an illustrator file which contains linked images. I want the images to link to images in a different folder on a different hard drive. They are the same images, but just in a different location.
I am thinking of temporarily changing the name of the first hard drive (which the images are currently linked to), in order to break the original image links. That way, I can re-open the illustrator file, and when it asks me to find the links, at that point I can direct illustrator towards the links on my other hard drive.
I will then save the file with the images linking to the images on the new hard drive.
At that point I will re-name the first hard drive back to it's original name.Will all of my other illustrator files loose their links if I temporarily change the name of my hard drive, and then change it back to it's original name?
(I have used this technique by changing folder names, and it has worked. But I was afraid to change the name of my Hard Drive because there are a guzillion files on it, and I can't afford for my illustrator files to lose any of their links.)
View 1 Replies
View Related
Jan 18, 2013
A strange thing happened just now that I don’t recall having seen before.
I have a number of simple objects, all the same fill colour, no stroke and none of them overlapping.
When I make them into a compound path they sometimes lose all their colour.
I have checked winding order, even/odd fill and that sort of thing but since none of the objects overlap, that shouldn’t make any difference anyway.
This doesn’t happen every time, so what could be causing it?
View 6 Replies
View Related
May 6, 2013
Illustrator cs6
OS : windows 7 32 bit
CPU : interl(R) Xeon(R) CPU E5462 @ 2.80GHz 2.79GHz
Memory : 4Gb
VGM : ATI Radeon HD 2600 XT 256 MB
When I resize image, I press shift & alt button. And all image were outline stroked.
View 2 Replies
View Related
