Excel Chart Into MSDataReport

[Fabian von Romberg]

Hi,

I want to insert an Excel Chart into a MSDataReport, I can do so using the
image control from the MS DataReport. But the results when printed are the
expected ones. The quality is poor, low resolution.

I have tried using the Function copypicture and export from the chart
object.

Is there any way to export the picture at a higher resolution?

Any help will be appreciated.

Thanks in advance,
Fabian von Romberg

 

[Jon Peltier]

Fabian -

I assume the MSDataReport is a publication quality output. Exporting the
chart as an image file (as well as copy-paste as bitmap and copy picture
as bitmap-paste) only give you something equivalent to the screen
resolution, generally 96 dpi. Pub quality is generally 300 or 600 dpi. I
wonder if you could blow up your chart by a factor of 300/96, export
that, then change the resolution of the exported image to 300 dpi in an
image processing program. (I've never had to do this, but it's the first
thing I'd try.)

The lack of publication quality output is one of the ongoing criticisms
of Excel.

- Jon