Illustrator :: Fill And Text Editing On Excel Imported Bar Graph
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'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.
I have exported a file from a program called Aspire (used for CNC router modelling) in 3 formats. AI, EPS and DXF. Aspire is a vector program. The file is a bunch of text that I have carved into wood using the Aspire program output (toolpaths)
Now I want to import the file into CorelDraw to cut a vinyl outline of the text so I can place the vinyl over the timber and remove the cut letters and then spraypaint the letters that are cut into the timber. If I can cut the the vinyl exactly the same size as the router has cut the wood I can stick the vinyl over the wood and spraypaint into the grooves which saves a huge amount of time to make the sign.
However, what I need to be able to do is fill all the letters in Corel Draw and get rid of the outline pen in the file as the vinyl cutter software will cut the letters twice if I have the fill and the outline but it will not cut the outline by itself. So I need all the letters just to be filled (any colour is OK) to run the program that controls the vinyl cutter.
I have imported each file type into CorelDraw (one at a time)and and in each case have tried to fill the letters but I can't get CorelDraw to fill the letters properly. Say with letter "a" it will fill the vectors surrounding the letter but also fill the centre piece of the "a" and even if I select the centre piece of the "a" separately I cannot "unfill" that bit. I can change the centre piece to white and it look like its "unfilled" but that won't work with my vinyl cutter. It will not cut out the centre piece unless I can find a way to unfill the centre piece.
Same problem with all the letters that have a vector inside another closed vector (like p,q,e,g,o etc)
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.
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.
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 took a snapshot of a picture off my pdf file and opened it up in illustrator and now it has the circle with the slash through it, how can i edit it and draw on top of the imported image?
I want to be able to edit text by editing a cell in excel. I am not sure if there is any way to do it with AutoCAD LT 2004 and Microsoft Office Excel 2003.
How to put text inside a line and then bend both of them to fit a line in graph. I've made a line at 22 points and then I've put text inside. Thought it would look cool. How do I make them become one so that I can bend them together? And how do I bend them the easiest way?
Is it possible to use an imported text as a number? I would like to import a .txt tab formatted file containing some values (ex: 22.5; 50.00; 150.00, etc.), and I want to treat those values as numbers in my script. Is this possible?
I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
Importing excel files into AutoCAD drawings works nicely but the print is unreadable in some areas of the page. There seems to be no rhyme nor reason to how the plot will turn out.
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.
Whenever I go to appearance panel menu > Add new fill when text is selected, the add new fill button is grey and I can’t add a second fill. I can add a new fill to shapes, but not text.
I am trying to create a 3d surface by importing points from an excel file. I have been using "import points" in the 3d sketch mode, and checked off the box that says "create 3d spline." But this just causes Inventor to freeze and crash. My excel file had about 2000 points, all of which lie on the surface I want to create in Inventor.
Should this method work in theory, and do I just have too many points?
URL....i dropped it into xdpx ungrouped everything extracted the france shape and tried to fill it.i check and it is definitely a closed shape.i can manipulate the outline as normal but nothing i do fills it it's definitely not transparent to remedy this i draw a square under it, select both and subtract shapes this gives me a square with france cut out of it then i draw another square inside the former square but outside the france outline i move the square underneath, select both and once again subtract shapes finally i have my shape filled as i require.
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.
I'm converting everything to curves and then export to illustrator but when the file opens in illustrator text is often filled in 'o's and p's usually fill in solid or do other weird things .
I need to create a text with a rectangle background and a coloured border around this rectangle. Here is what I do:
- I create a text - I select the text and add a fill and a stroke that I then transform into a rectangle - I now have my "label" as I want it to be but now I need to rotate it.
Problem is I can rotate the text but fill and stroke don't follow, they remain horizontal and just adapt so that it still fits the text. As a result I have a rotated font with a big rectangle box. Can I rotate fill+stroke with the text?
I'm trying to link an Excel sheet to a new assembly but it is only listing half of the sheet parameters. I have done this before with no issues. I've also imported another sheet and it works fine. I copied and renamed a sheet I know that works deleting the data from it and coping the data I want and I get the same results. This lead me to believe there is something wrong with the sheet. See attached file.
Any way I can import data from an excel file in a predetermined range but variable workbook and sheet. For instance, in Station5.dwg I access cells B4:C15 on sheet STA-5 on workbook TerminalA.xls and then in Station6.dwg I access cells B4:C15 on sheet STA-6 on workbook TerminalA.xls, but all through just rerouting the sheet just as if I were to reroute an xref with the same scale and insertion point.
I'm trying to avoid a continual copy/paste of OLEs for each .dwg because I will have an average of 5 ranges to import from each sheet, of an average of 7 sheets per workbook, of an estimated 220 workbooks to work through. (7,700 ranges estimated so far is a lot of work).
I am having an issue with the lastest version of illustrator! When I try to highlight the text on the path. It goes it this diagonal/slanted direction so it looks like I'm not highlight the text at all. But it works fine, if I use the regular type too, I search forums for this such clicking the ctrl+H on my laptopt and this happens on my computer as well. The ctrl+H command did not work..
I am using Illustrator CC. My business partner is in CS6. When we save files to .pdfs or legacy versions, we lose the ability to use the character pallete. I can't change leading or use kerning tools. I am able to select the text box, and change letters, but that's it. I can't go in and select a line, and then change the leading. I can't select a line to change the kerning. When I open the version that my partner's worked on in CS6, I save it as a cc file. I'm not sure why we're losing all the editing capability. The box for "preserve Illustrator editing capabilities" is checked. We have always had different versions of Illustrator for the last 6 years we've worked together, and this hasn't ever been a problem.
I am using CS6. I have created some text with a gradient fill. I have converted it to shapes before addin the Fill. I appear to get a slight black shadow arround the letters. This appears to get worse when I Export it to png with a transparent background. This black shadow is not a stoke that I have added.
I have a relatively simple mass modeled in Rhino that I imported to a Revit Mass Family (via .sat file). I then placed walls, roofs, structure on the face of this mass. However I would like to be able adjust this mass, either in Rhino or Revit and the walls and structure adjust accordingly. Now however, if I reload the mass into my Revit family, and then reload the family to my model, and then attempt to Update to Face, the error "Faces defining this Element cannot be reacquired." and my only option is to delete the offending wall/roof etc.
Is this just a limitation in Revit/Rhino, or am I totally doing it wrong?
