Please enter a title. You can not post a blank message.
Please type your message and try again. I have hundreds of charts to do this with, so remaking all of the charts in Illustrator isn't really feasible. In addition, I must include error bars which I don't think Illustrator is able to do. I also need high resolution images which I why was told I have to use Illustrator in the first place that are publication quality. Thanks everyone, jenn.
This content has been marked as final. Show 62 replies. Why do you need to have Excel charts in Illustrator? And when you say "high resolution images", do you mean photos?
In that case, Illustrator is not what you should use to edit them. I think you need to better define your workflow in order for anyone to be able to help you out. The figures will eventually be published in a scientific journal. Apparently a lot of the journals need figures prepared in Illustrator. I have a large number of column charts with error bars that were prepared in Excel. In previous versions of both Excel and Illustrator, I was able to copy and paste the graph into Illustrator - where I then could ungroup the graph and work with formatting issues fonts, size, colors, etc.
I can no longer do this. These I am not having a problem with. I am able to open the image in Illustrator, add labels and change constrast if need be just fine. I guess I don't have a clear reason why these need to be in Illustrator, other than that is what I was told and what our group has always done in the past.
The progress I have made is saving the chart in Excel as a. I am able to change fonts and edit colors. However, I am still having trouble ungrouping the graph and moving columns for ex. What happens is the inside of the column moves but the outside trace stays behind. I'm still trying to find an easier way to work with this. Maybe Illustrator isn't the best program to use, but unfortunately I don't have much of a choice. Jenn, when converting those Excel charts to. That seems to explain your trouble. Delete that selection, then do a multiple ungroup. I copy and paste scientific charts and graphs from Excel into Illustrator with no problem.
Yes, there are still extraneous clipping masks and weird groups, but I make sure the chart is formatted correctly in Excel so I don't have to do anything except resize it in Illustrator.
This workaround doesn't work for me at all. Upon opening the pdf in Illustrator I get a message "An unknown shading type was encountered". Then it opens, but all the info in the legend looks like this:! If it's needed to be made in illustrator, is that because of the export feature?
To make it an. That can also be done in indesign, and i believe that clears out a lot of trouble And even with a tool from Woodwing plug-in that can make upon styles you can easily asign to those hundreds of charts How about them apples! It can't be that important for the journal in which app their content is made? An options dialog will appear, try the default options.
Then go to AI and paste. The chart will come in as a vector graphic. I am busy trying what Ray Craighead has suggested. The graph simply does not paste into Illy not matter which option is selected.
What might I do wrong? OSX Any "Copy Picture" options will work. Then go to Illustrator and paste into a document. You get a vector chart. Here's a little movie that demonstrates the steps. FWIW This movie has text caption. Hi Ray Thanks so much for the trouble taken. I see in another thread the problem seems to be with Excel !
Wonder if there is any "cure", or if I have to reinstall Excel ? I guess there are some advantages to being the last to upgrade.
I have trouble finding what you show on screen shot. I have tried formatting Chart Area and have the formatting palette open. But can't see that option. Attached Images Picture With that dialog open, click the X axis on your chart, and it should switch to the Format Axis dialog at least it does so for XL for Windows. Or, close the dialog, select the X axis and then open the format dialog.
Now you should see something like the screenshot I attached earlier. If you check the 'layout'-'axis'-'more horizontal properties' And then you will find the 'low' for x-axis setting. Related articles:. Hypnos says:. May 14, at am.
Chandoo says:. May 14, at pm. May 15, at am. Andreas Lipphardt says:. May 29, at am. July 15, at pm. What is the best micro charting tool for Excel? September 5, at pm. Mrayo84 says:. October 19, at am. November 22, at pm. November 23, at pm.
Switch to the Charts tab of the Excel ribbon and select a chart type from the Insert Chart group. You should start with a single column of Y-values and a set of X-values with each X variable in its own column and all X values next to each other. Then click the Specify Value button. I have tried formatting Chart Area and have the formatting palette open. Choose the "Series" tab and make the bins column the Category X-axis labels, with the frequency values being the series values. Grahams, Adrian. Warning: Excel does not allow bars of unequal width, so we will restrict ourselves to equal width bins.
April 9, at am. April 14, at am. April 15, at am. Pedro says:. May 6, at pm.