Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default change chart print size

I cannot change the size of the printed chart in office 2007.
In 2003 it was done using un selecting the "fit to page" button.
In 2007 I have a "scale to 100%" but disabled...

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default change chart print size

Hi,

When you say you are clicking the Fit to Page button do you mean the Option
button on the first sheet of the Page Setup dialog box?

If so this option is still available in 2007. Set the print range and then
choose the Page Layout tab. Open the Width dropdown or the Height dropdown
and choose the number of pages. If this is not enough there is a little
dialog box launcher at the bottom right of the Scale to Fit group on the Page
Layout ribbon. This will take you to the old familiar screen.
--
Cheers,
Shane Devenshire


"Safra" wrote:

I cannot change the size of the printed chart in office 2007.
In 2003 it was done using un selecting the "fit to page" button.
In 2007 I have a "scale to 100%" but disabled...

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default change chart print size

Hello,
Thank you for the answer.
This works for printing a data sheat, but for chart it dosent work.
When I select a chart and try to print it, I cannot print it on part of the
page.

Eli



"ShaneDevenshire" wrote:

Hi,

When you say you are clicking the Fit to Page button do you mean the Option
button on the first sheet of the Page Setup dialog box?

If so this option is still available in 2007. Set the print range and then
choose the Page Layout tab. Open the Width dropdown or the Height dropdown
and choose the number of pages. If this is not enough there is a little
dialog box launcher at the bottom right of the Scale to Fit group on the Page
Layout ribbon. This will take you to the old familiar screen.
--
Cheers,
Shane Devenshire


"Safra" wrote:

I cannot change the size of the printed chart in office 2007.
In 2003 it was done using un selecting the "fit to page" button.
In 2007 I have a "scale to 100%" but disabled...

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default change chart print size

Hi,

From your response it appears that you are not talking about "fit to page"
but instead "Scale to fit page".

If that is the case, then you can stop looking for this feature, it was
removed from 2007 so you will need to use my first suggestion to overcome
that problem. I know it's not the same exactly, but this is what we are
going to have to live with, at least for a while.

You can get a slightly large chart on the page if you move the chart to a
Chart page. You might want to try that.
--
Cheers,
Shane Devenshire


"Safra" wrote:

Hello,
Thank you for the answer.
This works for printing a data sheat, but for chart it dosent work.
When I select a chart and try to print it, I cannot print it on part of the
page.

Eli



"ShaneDevenshire" wrote:

Hi,

When you say you are clicking the Fit to Page button do you mean the Option
button on the first sheet of the Page Setup dialog box?

If so this option is still available in 2007. Set the print range and then
choose the Page Layout tab. Open the Width dropdown or the Height dropdown
and choose the number of pages. If this is not enough there is a little
dialog box launcher at the bottom right of the Scale to Fit group on the Page
Layout ribbon. This will take you to the old familiar screen.
--
Cheers,
Shane Devenshire


"Safra" wrote:

I cannot change the size of the printed chart in office 2007.
In 2003 it was done using un selecting the "fit to page" button.
In 2007 I have a "scale to 100%" but disabled...

Thanks

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
change point size of all points in an xy chart kilter Charts and Charting in Excel 4 May 11th 23 03:43 AM
option to change print size is greyed out C Fowler Excel Discussion (Misc queries) 2 November 21st 06 02:16 PM
Change Chart Size bhavesh Charts and Charting in Excel 1 August 2nd 06 10:30 AM
How do I change the size of the print in a drop down list? rwpjim Excel Discussion (Misc queries) 1 February 17th 05 02:12 PM
How do I change the size of the text box in a flow chart? Breanne Charts and Charting in Excel 1 January 6th 05 06:05 PM


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

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

About Us

"It's about Microsoft Excel"