My charts resize just fine when I used Fit to 1 Page
Is your chart verrrrry large?
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Rontamale" wrote in message
...
When I have a worksheet which includes a chart that is big in size and
then I
want it to print in one page then I use the fit to function in the page
property window and select either a percentage or the number of pages
(i.e,
tall x wide).

Once I print or do print preview the cells are shrunk so the fit to
whatever size I requested but somehow the chart does not shrink. I looks
as
if it is an independent object. This is deceiving particularly in the page
break preview which does show that my chart will fit inside my page but
when
I print it does something completely different. Excel 2003 did not have
this
problem I just noticed it in excel 2007.