Convert (Export) Excel Chart to EPS Using Adobe Postscript

You may need to export a nice chart from Excel to EPS so that you include it in your Latex project. Here is one way how you do it.

1. You need to install Adobe Universal PostScript Windows Driver Installer 1.0.6 (or newer). If you have Vista or Windows 7 or some newer version run the installer with compatibility for Windows XP SP3.

– To set the compatibility for the installer, right click the file and select "Properties". Then from the "Compatibility " tab select "Run this program in compatibility mode for:" and select "Windows XP (Service Pack 3)"

 Select Compatability Mode

2. Open your Excel File.

3. Select your chart.

4. Select from the (File) menu print

5. Select the Adobe printer in my case this is "Generic PostScript Printer"

6. Ensure that "Select Chart" is the selected option in "Print what" area. If you did not selected the chart then this will option will not be selected. Go to Step 3.

7. Select print to file check box.

8. Go to Properties

Print Dialogue Box

9. In the properties dialog window select "Layout" tab then press "Advanced" button

10. In the Advanced properties dialog window, under the node "Postcript options:" select "Encapsulated Postscript (EPS)"

11. In the printer dialogue window, when you press "Print" you will be asked for the file name to be saved. You are not asked ensure that you have selected "Print to file" Step 7. Write the path and the file name something like "c:\". If you don't include the full path I don't know where the file will be saved by default.

12. Use ps2eps to convert the saved PS format file into EPS format.

Tags: , , , , ,

{ 1 comment to read ... please submit second! }

  1. This procedure worked great – thanks!  I easily created .eps files from Excel charts, one file per chart, that can be read by Adobe Illustrator for one example.  They are to be submitted to a scientific journal publisher. In Step 11, if you only put in a file name with no pathway, the file is saved in the same folder that the Excel file is located.  Not sure if Step 12 is needed or not.

{ 0 Pingbacks/Trackbacks }

Leave a Reply

Your email address will not be published. Required fields are marked *