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
|
|||
|
|||
Chart does not print properly even if shows ok in page break previ
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. |
#2
|
|||
|
|||
Chart does not print properly even if shows ok in page break previ
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. |
#3
|
|||
|
|||
Chart does not print properly even if shows ok in page break p
nope, my chart is small. But you gave me an idea. I asked a coworker to try
one of my files that I know have this problem and in his computer everything looked ok. It must be that my excel 2007 is corrupted. I know my IT dept will opt to reinstall the whole thing since it would be very unlikely that they can find the root cause. thanks for the help. "Bernard Liengme" wrote: 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. |
#4
|
|||
|
|||
Chart does not print properly even if shows ok in page break p
I have the same problem, regardless of the size of the chart. Did your
reinstall fix your problem? "Rontamale" wrote: nope, my chart is small. But you gave me an idea. I asked a coworker to try one of my files that I know have this problem and in his computer everything looked ok. It must be that my excel 2007 is corrupted. I know my IT dept will opt to reinstall the whole thing since it would be very unlikely that they can find the root cause. thanks for the help. "Bernard Liengme" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|