Moving charts to another worksheet

<< Click to Display Table of Contents >>

Moving charts to another worksheet

When you create a new chart, it will always be inserted into the current worksheet. Of course you can change its position whenever needed:

To move a chart to another place within the current worksheet, just select it with a mouse click and drag to the desired location.

In case you want to move a chart to a different worksheet, proceed as follows:

1.Click to select the relevant chart.
2.Choose the command Chart location chart_location_icon on the contextual ribbon tab Chart | group Position.
3.Choose the desired option in the opened dialog box (see below) and confirm with OK.

The chart is moved accordingly.

Available options:

▪As new sheet

When you choose this option, the chart will be transferred to its own chart sheet. PlanMaker removes the chart from the current sheet, creates a new chart sheet for it and places the chart there.
A "chart sheet" is a special type of worksheet: It doesn't contain any table cells, but solely the chart in its full size. On such sheets, only commands related to editing charts are available.

▪As object in ...

When you choose this option, the chart is placed as an object in the specified worksheet, as usual.