Ask Your Question

How to print ONLY the Chart?

asked 2017-04-30 19:44:08 +0200

abi gravatar image

Print ONLY the Chart ... Not entire SprdSht?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2020-04-27 18:20:09 +0200

Jacques Guddebuer gravatar image has the right answer.

Set the print ranges in "Format > Print Ranges" so that the cells marked as "being on one page" more or less match the chart size.

Go into "File > Print Preview" and adjust the zoom factor so that the cart is more or less the size of the page.

Select the Chart! But only select it, do not put it into "editable" mode, otherwise you won't even get the print menu.

Go into "File > Print" and select "Range and Copies: Selected Cells". This will blend out the spreadsheet, leaving only the chart in the preview minipreview. The chart should occuy the correct area, select with the preview zoom factor earlier.

Now print.

print dialog

edit flag offensive delete link more

answered 2020-04-28 00:57:11 +0200

KenT gravatar image

updated 2020-04-28 00:58:15 +0200

How to print a chart

  1. Left-click on the chart to select it.
  2. Select Main Menu>Print to open the Print window
  3. In the Print window, select the printer you wish to use, and in the “Range and Copies” highlight “Selected cells”. Even though the chart is not just a cell, this action should show a preview of the chart in the preview pane.
  4. If you wish to adjust the print, cancel this Print window, go to Main Menu>Format>Page >Page tab to change Portrait/Landscape, margins, and “Centred”, and the Sheet tab to change the scale.
  5. Go back to Main Menu>Print and tick “Selected cells” to check the preview again.
  6. Click the “OK” button to Print the chart.
edit flag offensive delete link more

answered 2017-04-30 20:57:36 +0200

updated 2017-04-30 21:00:13 +0200

Ciao, did you try selecting only the chart and choose "only the selection" in the print options?

If my answer helped you, vote it with ✔ (here on the left)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-30 19:44:08 +0200

Seen: 1,579 times

Last updated: Apr 28