How do I get four charts on a sheet?

[Catherine]

Hello

I'd like to know how to get four charts on a chart sheet, not a regular
sheet.

Any help would be greatly appreciated.

Thank you in advance.
Catherine

 

[Andy Pope]

Hi,

You can use the Location dialog to set the charts to be objects on a
blank chart sheet. You will then need to size and arrange the chart
objects. Right click the chart and pick Location... from the context menu.

To create a blank chart sheet press F11 making sure the active cell is
not near or containing data.

Cheers
Andy