ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I get four charts on a sheet? (https://www.excelbanter.com/charts-charting-excel/134502-how-do-i-get-four-charts-sheet.html)

Catherine

How do I get four charts on a sheet?
 
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

How do I get four charts on a sheet?
 
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

Catherine wrote:
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



All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com