I am a newbie trying to get excel charts into LaTeX as eps/pdf files. I had mixed success doing this and wanted to learn of better ways of doing the same:
1. pdf files: I could print selected plots (charts) from Excel to pdf using pdfcreator. I used graphicx with pdftex and am able to see them using LaTeX->pdf. The problem here is that there is a lot of whitespace between the figure and its caption (~0.5-0.7") which does not look very good in a scientific publication
. This is the code I used\usepackage[pdftex]{graphicx}
......
\begin{figure}[htbp]
\centering
\includegraphics{width=1.00\textwidth]{filename.pdf}
\caption{Some figure}
\label{fig:Fig1}
\end{figure}
.....
Is it possible to move the captions higher up into the whitespace region? (I dont think this is possible, otherwise LaTex would have probably done it). Are there better ways of writing excel charts to pdf files?
2. I installed Adobe Postscript printers and set them up to print to FILE to get eps figures of these charts. I can print to eps figures and can see them in gs, but when I tried to include them in a TeX file using dvips and graphicx with LaTeX->ps->pdf, all I get is a blank file even without any text. For eps files from gnuplot, I get the figure without the remaining text in the document (not even the captions).
\usepackage[dvips]{graphicx}
(or)
\usepackage[dvips]{epsfig}
....
\begin{figure}[htbp]
\includegraphics{width=1.00\textwidth]{filename.eps}
(or)
\epsfig{figure=filename,clip=,width=1.00\textwidth}
\caption{Some figure}
\label{fig:Fig1}
\end{figure}
A problem with EPS files in Windows/DOS seems to be the bounding box specifications. I came across a fix for this problem from a ftp download site (wisc.edu, do not remember the exact link) but could not download the file. Is there a better way to directly print LaTeX compatible eps files in Windows ?
Thanks,
