Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 857
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i create a dashboard in excel 2003 ? Jayne Loveman Excel Discussion (Misc queries) 1 January 2nd 08 09:19 PM
How do I create a dashboard using Excel 2003? Jennifer D Charts and Charting in Excel 2 September 26th 07 08:46 PM
How do I do dashboard charts in Excel Nick Cheng Charts and Charting in Excel 1 August 16th 05 03:00 PM
How do I do dashboard charts in Excel Nick Cheng Charts and Charting in Excel 2 July 9th 05 02:31 AM
Creating a Dashboard SavvySam Excel Discussion (Misc queries) 2 May 25th 05 06:29 PM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"