Microsoft Office Tutorials and References
In Depth Information
Creating a Standalone Chart
Basic Tasks with
Charts
Tip: You can resize a chart in another, slightly more circuitous way. You can set the Height and Width
boxes in the Chart Tools | Format➝Size section of the ribbon. Although this isn’t as quick as dragging the
chart edge, it lets you set the size exactly, which is indispensable if you have several charts on the same
worksheet and you need to make sure they’re all the same size.
Creating a Standalone Chart
Even without your input, Excel usually makes common-sense choices, so you can
often build a chart without needing to tweak any of these options.
You have two options for placing charts in a workbook. You can create an embedded
chart, which appears in an existing worksheet (usually next to the appropriate data),
or you can create a standalone chart, which appears in a new worksheet of its own
(Figure 19-6).
Figure 19-6:
A standalone chart
lives in a separate
worksheet that
doesn’t have any
other data and
doesn’t include the
familiar grid of cells.
Ordinarily, when you pick a chart type from the ribbon, Excel creates an embedded
chart. However, you can easily switch your chart over to a new worksheet if you’re
running out of room—just follow these steps:
1. Right-clickthechart,andthenchooseMoveChart(or,selectthechart,and
thenchooseChartTools|Design Location MoveChart).
The Move Chart dialog box appears (Figure 19-7).
 
Search JabSto ::




Custom Search