Excel 2003: Creating a dashboard and smaller charts get squished

[Wink]

Hi- I'm creating a dashboard with some large and small line charts using the
"Camera" functionality.

The display looks great, but when I click Print Preview or Print, the chart
area on the smaller charts gets squished and unreadable. I have to exit
without saving in order for the charts areas to be viewable.

Any suggestions?

 

[Shane Devenshire]

Hi,

As with any graphic, if you make it too small the print preview screen may
not be able to display it properly, and for you printer the print drivers and
maximum resolution will effect the printout. I made a small Camera tool
chart and in print preview it looked bad, however, went to the Page Setup,
Sheet tab and set the zoom to 300%. Now the chart looked just fine.

You might consider just taking a chart or a copy of your chart and making it
small. Two charts can get there data from the same source, no real need for
the Camera tool.

 

[Wink]

Thank you for your response. My issue is that in print preview it doesn't
just display the plot area poorly it actually takes the plot area and
consolidates it to 1 row (best way to describe) even when I exit print
preview it still consolidates the plot area.

I have to then keep clicking into the plot area to find the right point to
drag the plot area back to it's original dimensions.

Not sure why this is happening with the smaller charts and not the bigger
ones.