Chart Distortion Problem

[smartin]

Excel 2003:

I am building a dashboard report using the Camera function to assemble
many small charts images on one worksheet.

Everything looks fine until I try to print (or print preview) the
dashboard. What happens is the chart compresses the y-axis into a
useless blur. I posted a small (8k) graphical example here:

http://vfdrake.home.comcast.net/~vfdrake/files/excel/chart_distortion.png

Any explanation/workaround?

 

[Jon Peltier]

Is each camera object only a picture of a chart? If so, don't use the camera
tool, instead make a live copy of the actual chart and place it in the
report. The camera tool is a memory and performance pig, and it is prone to
problems like you describe.

- Jon