View Single Post
  #2  
Old September 25th, 2004, 06:27 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Mardi -

Since your charts are so small, the narrow bars are also small, and the rounding of the size
into pixels is irregular. Some might round to 3 pixels and others to 4. That's a much more
visible difference than if some rounded to 23 and others to 24 (if the bars are ~6 mm or ~0.25").

Normally I advise people to create their Excel charts at the size they want the chart after
pasting into another application. This might be a case where I'd suggest you create your charts
in Excel at a different size than their ultimate size in PowerPoint. Make them 2 or 3 times
their final size, paste as pictures in PowerPoint, and rescale them there.

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

Mardi Caulfield wrote:

I'm pasting bar charts (as pictures) into powerpoint slides. (around 300 of
them).

The charts are EXTREMELY tiny - font size 3pt (autoscale off!) - i've run
the excel gauntlet with axis truncating, fonts distorting etc. and have found
fixes for most of it. (after 300 charts, my aunt's cat would have found it!)

The bars (when they are correctly sized, are 1mm wide)

HOWEVER - one tiny (and potentially project flooring) glitch remain beyond
my reach:

The bars, once pasted, are completely irregular sizes - some as small as
0.3mm - in the same graph!

Soooooo - I have been forced to (wait for this) UNGROUP each chart on the
slide, and then MANUALLY select each bar ( ehm, 1,800 of them) and change the
size to 1mm!!


I've worked on this for around 14 hours. I'm tired. I would so very much
like some help. From someone.

Please?