View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Wink Wink is offline
external usenet poster
 
Posts: 2
Default Excel 2003: Creating a dashboard and smaller charts get squish

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.

"Shane Devenshire" wrote:

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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Wink" wrote:

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?