Excel edit a chart: YOUR OBJECTIVE
In an Excel table, you recorded your company’s sales for the first three quarters of 2010. You already created pie charts for the first and second quarters, each on its own separate worksheet. But now you would like to shift both of those charts to the worksheet with the table containing the underlying data.
In this learning module “Excel edit a chart”, you will be shown how to reposition and resize charts.
Excel edit a chart: HOW DOES IT WORK?
When creating a chart, you can generate it either on a separate worksheet or as an object on the same worksheet as the underlying data. In either case, you can move the chart to the other location.
Excel edit a chart: Assuming you generated a chart on a separate worksheet and now want to move it to the worksheet with the underlying data, go first to the worksheet that contains the chart (as shown below):
Then activate the chart by clicking on it. As soon as you do that, the Chart Tools context tab will appear in the Ribbon along with its subordinated Design, Layout and Formattabs:
Now click the Design tab to reveal its functions in the Ribbon:
The Move Chart dialog box (explained below) will appear:
New sheet: Activate this option to place the chart on a separate worksheet. At the same time you activate it, you can type in a name for the new worksheet.
Object in: Activate this option to move the chart onto a worksheet of your choice. It is not uncommon to move a chart to the worksheet that contains the data table.
A list of all worksheets in the current workbook will appear:
For the current example, select the Revenues 2010 worksheet:
Conclude by clicking OK.
Excel edit a chart: As a result, Excel moves the chart onto the Revenues 2010 worksheet and deletes the Quarter1 worksheet:
If you move the chart so that it appears on the same worksheet as the underlying table, as in our example, you can expect Excel to to position it and reduce its size in such a way that overall readability of data and chart is maintained.
Excel edit a chart: If you want to move a chart to some other position on its worksheet, place your mouse pointer on the chart’s frame. The mouse pointer will change to a four-way arrow: . Then, while holding the left mouse button depressed, you can pull or push it to a new location:
In our example, you want to place the pie chart for the second quarter’s sales onto this worksheet, as well. To make room for the Quarter 2 chart, you will want to move the Quarter 1 chart until it is flush with the left edge of the table, and then reduce it in size so there will be room for the next chart just to its right.
Excel edit a chart: To reduce the chart’s size, select the chart by single-clicking the frame surrounding it. When you move your mouse pointer to any of the frame’s corners, the pointer will change to a slanted double-headed arrow (shown below):
Now, while holding the left mouse button depressed, pull the corner in toward the middle of the chart. Release the button when you are satisfied with the chart’s size:
Excel edit a chart: HINT
If you want to maintain the ratio of the chart’s height to width, press and hold the [Shift] key while resizing it.