Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a dashboard in excel 2003 ? | Excel Discussion (Misc queries) | |||
How do I create a dashboard using Excel 2003? | Charts and Charting in Excel | |||
How do I do dashboard charts in Excel | Charts and Charting in Excel | |||
How do I do dashboard charts in Excel | Charts and Charting in Excel | |||
Creating a Dashboard | Excel Discussion (Misc queries) |