Re: Excel CopyPicture and PowerPoint
From: Keith R (nospam_at_nospam.com)
Date: 04/28/04
- Next message: gmaikell: "Re: Resizing Pie Chart"
- Previous message: MDW: "Re: Charting Options Other Than Excel?"
- In reply to: Jon Peltier: "Re: Excel CopyPicture and PowerPoint"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Apr 2004 09:18:45 -0400
I learn something new in this group every day
8-)
"Jon Peltier" <DOjonNOT@SPAMpeltiertechME.com> wrote in message
news:OjGRTwJLEHA.1144@TK2MSFTNGP12.phx.gbl...
> Keith -
>
> Those are the correct settings. Appearance as onscreen I guess means all
> the colors will show (if it's a black and white printer, presumably the
> colors will be turned to gray). Size as on screen is self-evident.
>
> Picture format means you are copying a metafile, that is, a vector
> representation which contains all the data to redraw the chart from its
> constituent lines, shapes, and labels. This means you will not get pixel
> distortion if you resize the chart, and you can ungroup the chart in the
> target application.
>
> Printer format means bitmap, jpg, png, or gif, any format that converts
> the objects into pixels. If the image will remain the same size and
> shape, this is probably the best, and for web pages, it's the only way
> to go. If you resize one of these, you will get jagged edges where the
> pixels in the image no longer line up with the pixels in the screen. You
> should use png or gif for charts; these formats are good for images with
> large regions of a constant fill color. The jpg format is better for
> photographic images which have continuously varying gradients of color.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Keith R wrote:
>
> > Sorry if this is a silly question, but on the following line:
> >
> >
> >>>> ch.CopyPicture xlScreen, xlPicture, xlScreen
> >
> >
> > are you sure these the right parameters to use for [(appearance, format,
> > size)]? If I were to guess, I'd think it was (appearance, appearance,
> > appearance) and I'm not sure how XL would interpret that, if it is the
case.
> >
> > Also, is there a difference in quality between copypicture xlscreen vs
> > xlpicture? I assume xlpicture gives the same things as "copy as
printed",
> > which I would think might provide a higher resolution than xlscreen, but
> > then, I haven't tested to be sure....
> >
> >
> >
> >
>
- Next message: gmaikell: "Re: Resizing Pie Chart"
- Previous message: MDW: "Re: Charting Options Other Than Excel?"
- In reply to: Jon Peltier: "Re: Excel CopyPicture and PowerPoint"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
