Brian -

You crazy PowerPoint guys with your fancy font formatting (not to
mention alliteration!). Can't you get by with Arial Narrow 10 pt???

All joking aside, I appreciate your comments. What makes this so
frustrating is Excel's stubbornness in allowing precision formatting of
its charts. When you have it almost working, you then come across some
variation that doesn't cooperate. Did you know you get different results
if you do the height and width in reverse order? The way I eventually
used *seemed* to be more reliable. You also get different results
depending on whether the chart is selected, or whether the chart object
is selected, or whether the chart is not selected at all. Most reliable
results come when the chart itself (the chart area) is selected.
Sometimes you need to run the program more than once; sometimes a
subsequent trial works, occasionally not.

I think most people would prefer a chart that was sized from the inside
out: plot inside area, then plot area, chart area, and finally whatever
chart object is required to fit it all in. But in Excel you need to
specify the container size (the chart object) first and foremost, and
each successive layer inside the onion has to conform to every prior
level of constraints. Finally, the most important dimensions, those of
the plot inside area, can't even be directly set, only through algebra
and iteration.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Brian Reilly, MS MVP wrote:

Hi Jon,
Just wandered over here, haven't here in a while. Downloaded your
sample addin and did a quick test. I'm getting inconsistent results.
Mostly correct. Occasionally not, then correct again.

two column 2d charts with data

red 1
white 2
blue 3


red 300
white 400
blue 500

change plot area in 2nd chart to smaller
change font in second chart to 18 point

resize everything. Inside left axes are identical, good
Inside plotarea widths are usually the same which is good. Sometimes
not the same. But almost always the Inside plot area positions are
different relative to the chart area which would be nice when using
these are sequential pages in PPT.

Brian Reilly, PowerPoint MVP