Microsoft Office Tutorials and References
In Depth Information
Editing and Adding to Chart Data
Basic Tasks with
Charts
Figure 19-7:
Using the Move Chart dialog box, you can
transfer the chart to a standalone worksheet (as
shown here) or shuffle it over to another
worksheet and keep it as an embedded worksheet.
(If you want the latter option, it’s just as easy to
select the chart, and then use a cut-and-paste
operation to move it to a new worksheet.)
2. Choose“Newsheet”,andthenenterthenameforthenewworksheet.
3. ClickOK.
Excel creates the new worksheet and places the chart on it. The new worksheet
goes in front of the worksheet that contains the chart data. (You can always
move the worksheet to a new position in your workbook by dragging the
worksheet tab.)
Note: You can move or resize only embedded charts—the ones that appear in floating boxes inside other
worksheets. If you’ve created a standalone chart, you can’t move or resize it. Instead, it automatically
shrinks or enlarges itself to match the Excel window’s display area.
Editing and Adding to Chart Data
Every chart remains linked to the source data you used to create it. When you alter
the data in your worksheet, Excel refreshes the chart with the new information
automatically. As long as Excel is set to automatic recalculations (and it almost always
is), there’s no such thing as an out-of-date chart.
Note: Excel has no restriction on linking multiple charts to the same data. So, you can create two types of
charts (like a pie and a column chart) that show the same data. You can even create one chart that plots
all the data and another chart that just uses a portion of the same information.
However, there’s one tricky point. Any range you define for use in a chart is static ,
which means it doesn’t grow as your data grows. That means that if you add a new
row at the bottom of the range, it doesn’t appear on the chart because it’s outside of
the chart range.
 
Search JabSto ::




Custom Search