How Do I Create an EPS File From an Excel Chart?

Using Microsoft Office 2000 on a Windows NT machine, this is what you can do:
  1. In the PageSetup menu remove all margins and any header/footer.
  2. Also in PageSetup make the printing orientation Portrait.
  3. In the Print menu choose a postscript printer, such as puccps or mathg109chp.
  4. Print to file, give it a name with a ".ps" suffix.
  5. The printer file from the previous step will be located in the directory that Excel is pointing to, (i.e., the directory you see when you choose Open from the the File menu.)
  6. Open the printer file in GSview.
  7. Choose the PStoEPS option in the File menu.
  8. Automatically calculate the bounding box (this gets rid of the white space.)
  9. Open the new EPS file in a text editor and delete all the lines inbetween:

This EPS file can be included in LaTex documents.

(If you know of an easier way, please let us know.)

Here is another easy way to make an EPS from any kind of document: You need Adobe Acrobat and Distiller 4.0 or newer on a Windows machine.

  1. Make whatever document you want.
  2. Print that document to a pdf file using the printer named "Acrobat Distiller".
  3. Open the pdf file using Adobe Acrobat.
  4. Use Crop tool to capture the part you need.
  5. Export as an EPS file. (Save as an EPS file for Acrobat 5.0 or newer.)
That's it. You may change resolution and other options in Property for the printer.