<< 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 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. |