View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Genie Genie is offline
external usenet poster
 
Posts: 6
Default "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.


.