Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
"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
Posted to microsoft.public.excel.charting
|
|||
|
|||
"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
Posted to microsoft.public.excel.charting
|
|||
|
|||
"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
Posted to microsoft.public.excel.charting
|
|||
|
|||
"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
Posted to microsoft.public.excel.charting
|
|||
|
|||
"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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Flowchart shapes don't scale with "print to fit" function | Excel Discussion (Misc queries) | |||
Charts on a "Common Print Area" | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
BUG?!: PP 2007 does display all "Paste as link" charts of Excel 20 | Charts and Charting in Excel |