If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2003: Creating a dashboard and smaller charts get squished
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? |
#2
|
|||
|
|||
Excel 2003: Creating a dashboard and smaller charts get squished
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|