View Single Post
  #28   Report Post  
Posted to alt.computer,microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
Robert Baer Robert Baer is offline
external usenet poster
 
Posts: 93
Default Excel print object?

GS wrote:
* Page breaks will not show in a chart because a chart is "in front"
or overlays cells.


PageBreaks don't show at all; - they reside in the cell where they are
inserted!

** Furthermore, a chart can take a rather large number of cells
(C6..Q38).

** Again, what code is needed to print a chart?


Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in their
respective location on a sheet*

* Not true; easy and simple when done manually:
1) Select the chart
2) File-- Print
Done.