Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Type
Basic Tasks with
If you do want to insert additional data to a range of data used in a chart, you have
• You can use the Home ➝ Cells ➝ Insert ➝ Insert Sheet Rows command. If you do,
Excel notices the change, and automatically expands the range to include the
newly inserted row. However, this command works only if you add a row into
the middle of your data. If you try to tack a row onto the end, Excel still ignores
it, and you’ll need to use the solution described in the next bullet point.
• After you insert new rows, you can modify the chart range to include the new
data. This approach is the most common, and it’s quite painless. First, select
your chart by clicking the edge of the chart box, or a blank space in the chart.
Excel highlights the linked worksheet data with a colored border. Click this
colored border, and drag it until it includes all the new data you want. When you
release the mouse button, Excel refreshes the chart with the new information.
Excel is smart enough to adjust your chart range in some situations. If you drag
your chart data to a new place on your worksheet, Excel updates the chart to match
Changing the Chart Type
When you create a chart, you choose a specific chart type. However, in many
situations you may want to try several chart types with the same data to see which
visualization tells your story better. Excel makes this sort of experimentation easy. All you
need to do is click your chart to select it, and then make a different choice from the
ribbon’s Insert ➝ Charts section. You can use this technique to transform a column
chart into a pie chart.
You can also choose Chart Tools | Design ➝ Type ➝ Change Chart Type to make a
choice from the Change Chart Type dialog box, which looks just like the Insert
Chart dialog box shown in Figure 19-3.
How you print a chart depends on the type of chart you’ve created. You can print
embedded charts either with worksheet data or on their own. Standalone charts,
which occupy separate worksheets, always print on separate pages.
You can print embedded charts in two ways. The first approach is to print your
worksheet exactly as it appears in the Excel window, with its mix of data and
floating charts. In this case, you need to take special care to make sure your charts aren’t
split over a page break or positioned over some data you want to read in the
printout. You can check for both issues using Page Layout view (choose View ➝ Workbook
Views ➝ Page Layout View) or the smaller print preview that’s shown in backstage
view when you’re about to print your worksheet (make sure the chart isn’t selected,
and then choose File ➝ Print).