CCNC/CCNC Module 4/Creating charts and graphs/Moving duplicating resizing deleting

Moving, duplicating, resizing, deleting

These are some additional changes that can be made to charts and graphs whether within a worksheet or between open spreadsheets.

Move a chart within a worksheet by dragging

• Position the cursor over the chart.
• Hold down the left mouse button and drag the chart to its new position.
• Release the left mouse button.

Move / duplicate a chart within a worksheet using cut / copy and paste

• Click on the chart.
• To move: Edit->Cut OR To duplicate: Edit->Copy.
• Select a target cell.
• Edit->Paste.

Move / duplicate a chart between worksheets within a spreadsheet

• Click on the chart.
• To Move: Edit->Cut OR To duplicate: Edit->Copy.
• Click on the tab of the target worksheet.
• Select a target cell in the worksheet.
• Edit->Paste.

Move / duplicate a chart between open spreadsheets

• Click on the chart.
• To Move: Edit->Cut OR To duplicate: Edit->Copy.
• Click on the Window item in the menu bar and select the desired spreadsheet.
• Click on the tab of the target worksheet in the new spreadsheet.
• Select a target cell in the worksheet.
• Edit->Paste.

Resize a chart

• Click on the chart.
• Position the cursor over any of the eight handles.
• Drag the handle by holding down the left mouse button and moving the cursor.
• Release the left mouse button when the desired size has been achieved.

A resizing symbol will appear. The side handles allow you to resize the chart horizontally and the top and bottom handles vertically. Using these will cause the chart to appear flatter or longer.

The corner handles allow you to resize the chart either horizontally or vertically. By dragging these diagonally, you are able to resize a chart and keep its scaling.

Delete a chart

• Click on the chart.
• Press the Del key.