Microsoft Office Tutorials and References
In Depth Information
Change the Chart Source Data
12
chapter
Visualizing Data with Charts
3 Click and drag until the
selection includes all the
data you want to include in
the chart.
B Excel displays a blue outline
to show you the new
selection.
4 Release the mouse button.
C Excel redraws the chart to
include the new data.
Is there a way to swap the chart series with
the chart categories without modifying the
source data?
Yes. Excel has a feature that enables you to
switch the row and column data, which swaps
the series and categories without affecting the
source data. First click the chart to select it,
and then click the Design tab. Click Switch
Row/Column (
Is there a way to remove a series from a
chart without deleting the data from the
source range?
Yes. Click the chart to select it, and then
click the Design tab. Click Select Data (
)
to open the Select Data Source. In the
Legend Entries (Series) list, click the series
you want to get rid of, and then click
Remove . Click OK.
). Excel swaps the series and
categories. Click
again to return to the
original layout.
Search JabSto ::




Custom Search