Microsoft Office Tutorials and References
In Depth Information
Changing the Data Arrangement
Categories The items in the columns are the categories placed along the horizontal
axis of the chart. Categories might include months, quarters, stages of a project, or
some other unit by which the value can be measured.
Data Series The data series show the items that are being graphed, according to
the categories selected.
Values The data entered in the cells of the datasheet are scaled against the value
axis, which is the vertical axis.
By default, the datasheet includes data used to display the chart you add to your
page. The first thing you will most likely do when you open the datasheet will
be to delete the existing data so that you can enter your own. You can type the
values directly into the cells or copy and paste the information into the datasheet
from another source.
Changing the Data Arrangement
By default, the new Word chart displays the categories along the horizontal axis and the
values along the vertical axis, but if you choose, you can lip that configuration to display
your data differently.
To change the arrangement of the data in your chart, follow these steps:
1. Select the chart you want to change.
The Chart Tools tabs appear.
2. On the Design tab, in the Data group, click Switch Row/Column.
The chart is redrawn automatically.
Although you’re creating a chart for use in your Word document, you might want
to use data from other programs to create the chart. Because the chart datasheet is
actually an Excel worksheet, you can link to external data sources supported by Excel.
To display your choices for using external data in your Excel datasheet, click the Data
tab in the datasheet and choose the option in the Get External Data group that best
reflects the type of data you want to use. For more about working with Excel 2010,
see Microsoft Excel 2010 Inside Out , by Mark Dodge and Craig Stinson (Microsoft
Press, 2010).
Search JabSto ::

Custom Search