Brian Barker wrote:
At 20:38 12/11/2007 -0500, Richard Detwiler wrote:
I have a question regarding printing graphs from Calc.
In Excel, it is possible to create a chart in its own worksheet; then
when that worksheet is printed, it would automatically be scaled to
fill a page. Is there anything analogous to this in Calc?
If I select the graph by single clicking it, and select File > Print,
then under Print range, check "Selection", it still prints the entire
worksheet, even though the only thing selected is the chart. If I
double click the chart, then there is no option to print.
I realize that I can select a range that includes the chart, then
tell it to print the selection, but that is less friendly than
clicking the chart to select it. Plus, it doesn't solve the goal of
printing a chart that fills up a page, unless the size of the chart
fortuitously matches the size of the page, or I do some trial and
error with the print scaling to get it to match the size of the page.
I don't know any automatic way to do this, but there are some
techniques that may help:
o You can avoid anything else printing by pasting the chart (moving
or copying as you prefer) to a new sheet of your spreadsheet.
o You can scale the chart fairly easily like this:
- Examine your page format and acquaint yourself with the
dimensions of the *printable* area: the page dimensions minus the sum
of the margins.
- Paste your chart into cell A1 of a new sheet, so it appears at
the top left.
- Select the chart and go to Format | Graphic > | Position and
Size... | Position and Size.
- With "Keep ratio" ticked, set either Width or Height (as
appropriate) to the maximum printable size.
This process does work; thanks. It's definitely more cumbersome than
with Excel. I wouldn't mind dealing with this, but the question was
raised by a client who has moderate computer literacy, who needs to
print graphs only once every three months. I'm sure she'll be able to
work through it with a little help from me, but remembering it the next
time may not be certain ...
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
