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
|
|||
|
|||
"Print to Scale" Excel 2007 Charts
In Excel 2003, one could double-click a chart, print, and the chart would
auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. |
#2
|
|||
|
|||
"Print to Scale" Excel 2007 Charts
I will assume we are talking of an embedded chart (one sitting on a
worksheet) and not a chart sheet. In Excel 2003 (all earlier) you did not double click, you just single clicked to select the chart; then when you gave the print command the printout would have just the chart and it would fill the page (more or less) Exactly the same happens in Excel 2007. best wishes "Genie" wrote in message ... In Excel 2003, one could double-click a chart, print, and the chart would auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. |
#3
|
|||
|
|||
"Print to Scale" Excel 2007 Charts
If I try to print a Chart the default option seems to be, "auto-size to fill
a page". Click on the graph then Page Layout / Page Setup group / clion on arrow in lower right hand corner / Page Setup windown launches. This is where the graph print settings can be changed. OR type:- print chart - into EXCEL F1 Help Facility and there is a variety of options in here that may assist you. If my comments have helped please hit Yes. "Genie" wrote: In Excel 2003, one could double-click a chart, print, and the chart would auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. |
#4
|
|||
|
|||
"Print to Scale" Excel 2007 Charts
You are correct...single click. And, yes, it is a chart embedded in a
worksheet. Exactly the same process I have used in the past is not yielding the same result in Excel 2007. When single-clicking on an embedded chart (that has title/axes/legends formatted), the print preview does include just the chart, but chart has lost its formatting (titles, legends, axes are out of alignment), chart does not autosize to fill the page (it may fill half the page, 1/3 of the page). I've not encountered this before, and have used for over 10 years. Have uninstalled and re-installed Office 2007, but no joy. Any thoughts? Thank you again. "Bernard Liengme" wrote: I will assume we are talking of an embedded chart (one sitting on a worksheet) and not a chart sheet. In Excel 2003 (all earlier) you did not double click, you just single clicked to select the chart; then when you gave the print command the printout would have just the chart and it would fill the page (more or less) Exactly the same happens in Excel 2007. best wishes "Genie" wrote in message ... In Excel 2003, one could double-click a chart, print, and the chart would auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. . |
#5
|
|||
|
|||
"Print to Scale" Excel 2007 Charts
I cannot reproduce this. My titles all get printed and the chart fills the
paper with the margins as set. The normal advice when there is a printer problem is reinstall printer and make sure you have the latest drive. Tell us how things turn out Bernard "Genie" wrote in message ... You are correct...single click. And, yes, it is a chart embedded in a worksheet. Exactly the same process I have used in the past is not yielding the same result in Excel 2007. When single-clicking on an embedded chart (that has title/axes/legends formatted), the print preview does include just the chart, but chart has lost its formatting (titles, legends, axes are out of alignment), chart does not autosize to fill the page (it may fill half the page, 1/3 of the page). I've not encountered this before, and have used for over 10 years. Have uninstalled and re-installed Office 2007, but no joy. Any thoughts? Thank you again. "Bernard Liengme" wrote: I will assume we are talking of an embedded chart (one sitting on a worksheet) and not a chart sheet. In Excel 2003 (all earlier) you did not double click, you just single clicked to select the chart; then when you gave the print command the printout would have just the chart and it would fill the page (more or less) Exactly the same happens in Excel 2007. best wishes "Genie" wrote in message ... In Excel 2003, one could double-click a chart, print, and the chart would auto-size to fill a page. I am unable to print my newly-created Excel 2007 charts so they auto-size to print one-to-a-page (now requires several time-consuming steps for reformatting titles, axes, etc.). I do not have a "print to scale" option in my page setup. Printing to a Ricoh Aficio AP610N. Thanks so much. . |
Thread Tools | |
Display Modes | |
|
|