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.