Microsoft Office Tutorials and References
In Depth Information
The next button group, Location , comprises exactly one button— Move Chart . Clicking it brings an old,
pre-2007 dialog box in view (Figure 5-38):
Figure 5–38. Changing your sheets: the Move Chart dialog box
Clicking the default Object In drop-down arrow enables you to resituate the chart to one of the
other worksheets in the workbook—and remember: you get three worksheets for starters. The chart’s
location on the destination sheet corresponds to its original position on the original sheet. Clicking the
New sheet option puts the chart on a new sheet, manufactured for the purpose of receiving the chart.
That sheet is called Chart1 (sheet names can be changed, as we’ll see) and when the chart moves there, it
appears significantly larger than in its original version. ( Note : If you move the chart to a new worksheet,
it will still reflect any data entry changes you make in the source data. You can also copy a chart to a
different sheet via standard copy-and-paste procedures. The copy will also remain “live.”)
The final option, new to Excel 2010, is Draft Mode , on the far right end of the Design Button
groupribbon. This option withholds fancy formatting elements that may slow your computer processing
speed. When you’re ready to display the chart as it really appears, click Normal. In reality, Draft mode
won’t appreciably change the onscreen appearance of the chart in many cases.
Changing the Chart Default—and the -Second Chart 2
You may wonder what “chart default” means, because when we begin the charting process we choose
the chart we want—no chart is imposed upon us by default, is it? Well, no, not exactly, unless you do the
1. Select a chart range of data cells.
2. Click the F11 key.
What happens? What happens is that a column chart will automatically appear, assigned to its own,
new worksheet—and there’s your default. You’ve just engineered a veritable, one-click, 2-second chart—
and Excel has decided it’s going to be a column chart. But what if you want a 2-second line chart instead?
Just click the chart you’ve realized onscreen,
Click Change Chart Type on the Design Tab,