How to make two charts look exactly the same?

  • Thread starter Thread starter marsupilami
  • Start date Start date
M

marsupilami

Hi!

I'm using charts from excel in a report written in LaTeX. The chart
are converted to .eps by WMF2EPS. My problem is this;

I want a uniform appearance of all graphs in my report, but no matte
how much I try in excel the graphs appear sligthly different. I.e
borders or axes don't align properly when two graphs are printed nex
to, or above each other.

How can I make excel produce charts with attributes that are "exactly
alike (apart from the content that is)?

Help is greatly appreciated!

(copy-paste is NOT an option - fonts and sizes sometimes change when
chart is pasted
 
I've never used LaTeX and don't know much about your situation, but what I
do is just create one chart that is based on a named range, and change the
range so I'm actually using the exact same chart, again and again for
various sets of data, then copying to Powerpoint or Word. I find that
copypicture tends to keep things a little more standardized (dunno much
about EPS). For small workbooks, I tie the named range to a cell, so I can
just change the cell value to 1, 2, 3, etc. and have my graph update with
that set of data.
 
The problem is that many little things can throw off the size of the
inside plot area (defined by the axes), even if the "regular" plot area
is constant in size. The regular plot area contains the axis labels, and
if these have another significant digit in chart 2, it will have a
smaller inside plot area to accommodate it. You can only resize the
inside plot area indirectly, by changing the regular one.

There are two ways to prevent axis labels from changing the inside plot
area. Use a dummy series to provide axis labels, using an approach like
this:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Or using a routine like this:

http://peltiertech.com/Excel/Zips/AlignChartDimensions.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Keith said:
I've never used LaTeX and don't know much about your situation, but what I
do is just create one chart that is based on a named range, and change the
range so I'm actually using the exact same chart, again and again for
various sets of data, then copying to Powerpoint or Word. I find that
copypicture tends to keep things a little more standardized (dunno much
about EPS). For small workbooks, I tie the named range to a cell, so I can
just change the cell value to 1, 2, 3, etc. and have my graph update with
that set of data.
Click to expand...
 
Back
Top