Re: How to make two charts look exactly the same?

From: Jon Peltier (DOjonNOT_at_SPAMpeltiertechME.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 09:36:05 -0400

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 R wrote:

> 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.
>
> "marsupilami >" <<marsupilami.155y2l@excelforum-nospam.com> wrote in message
> news:marsupilami.155y2l@excelforum-nospam.com...
>
>>Hi!
>>
>>I'm using charts from excel in a report written in LaTeX. The charts
>>are converted to .eps by WMF2EPS. My problem is this;
>>
>>I want a uniform appearance of all graphs in my report, but no matter
>>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 next
>>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 a
>>chart is pasted)
>>
>>
>>---
>>Message posted from http://www.ExcelForum.com/
>>
>
>
>

Relevant Pages

  • Re: viewing big charts
    ... Thanks for all your time and help Greg, I will start with the code you ... > plot area size in order to accomodate the x-axis labeling. ... > even if you tell Excel to make the plot area a certain size and the chart ... > Dim ChtObj As ChartObject ...
    (microsoft.public.excel.programming)
  • Re: Maintain Aspect Ratio of 2D Plot on Different Monitors ??
    ... You can also specify the dimensions of the chart area of a chart sheet. ... Specifying the height and width of the plot area is more problematic, ... because Excel needs room for labels etc. ... Does XL 2007 provide options for specifying the physical dimensions ...
    (microsoft.public.excel.charting)
  • Re: Plot area
    ... The outermost border of the chart is the chart area. ... decorations is called simply the plot area. ... the chart, in the inner plot area, you see handles on the inner plot area. ...
    (microsoft.public.excel.charting)
  • Re: Excel Chart Plot Area Auto Size
    ... just to build upon your great suggestion I have applied a custom chart ... manual adjustments are made to the plot area). ... adjustment without losing important formats elsewhere in the chart. ... to auto resize again. ...
    (microsoft.public.excel.charting)
  • Re: Decreasing white space around graphs in Excel?
    ... I think you could get away with locking in the font size, and defining the plot area ... Of course, you need to adjust these sizes for labels, chart area size, etc. ... > Dim Prop as Chart.Property ... > Dim Holder as Variant ...
    (microsoft.public.excel.charting)