[Solved] Printing charts in Landscape

[artworksmetal]

I've been messing around with the "Position and Size" feature in charts. I don't completely understand it but I've managed to fill the page with my chart. Maybe what I want is not possible, but I was hoping to print a single chart on two or three landscape pages. But when I set the printer to landscape, it just prints very wide margins instead of filling the page. Do I need to just make a separate chart for each set of data that will fit onto a single page?
If there is a tutorial on how to use this feature I have not been able to find it.
One other weird thing, note in the screen print that the protect options are available. I don't know what happened there because they have been grayed out in all my previous resize attempts. So I'm not even sure what that means?
Thank you in advance for your help!

[FJCC]

To set the page to landscape, choose the menu Format -> Page. On the dialog that appears, choose the Page tab and set the orientation to Landscape.

Do you want one chart to span several pages? The simplest way to resize a chart is to click on it once so that green "handles" appear on it edges. You can then click and drag those handles to change the chart size. To see where page boundaries are, you can use the menu View -> Page Break View. It might be useful to first add dummy data in a column and row to the right of and below the area of the spreadsheet that you need to use. If you add data in rows 1 and 50 of column Z and then select View -> Page Break View, you will see an array of pages that you can use to guide your resizing of the chart.

[artworksmetal]

The first screenshot is what the chart looked like printed in landscape, so I knew how to do that. But the Page Break view suggestion really helped.
Once I did that, I poked around and figured out how to format the page as landscape. That's exactly what I needed. Then resizing the chart became elementary.

Thank you for turning a task I was struggling with into an easy one!

[John_Ha]

Thank you for turning a task I was struggling with into an easy one!

All of physics is either impossible or trivial. It is impossible until you understand it, and then it becomes trivial.

Ernest (later Lord) Rutherford, Nobel Prize.