Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

Including Datasheet Rows or Columns in a Chart

Summary: Controlling which datasheet information is graphed in a chart. (This tip works with Microsoft Word 6, Word 95, Word 97, Word 2000, Word 2002, and Word 2003.)

The charts created by Microsoft Graph are based on data contained in a simple spreadsheet called a datasheet. Microsoft Graph displays this data in row-and-column format. At the top of each column and the left side of each row is a control cell. Control cells are used primarily to select the column or row.

The control cell for a row is used to indicate whether information it contains is included in the chart. If the control cell includes an icon (besides the row number), the information in the row or column is included; no icon means it is not included. You can tell whether information in a particular column is included in the chart by whether there is a letter of the alphabet (A, B, C, etc.) in the control cell for the column.

To include data in a chart, follow these steps:

  1. In the datasheet, select the row or column you want included in the chart. Do this by clicking on the control cell for the row or column.
  2. Choose Include Row/Col from the Data menu.

If you fail to select an entire row or column, but instead select a single cell, Microsoft Graph 2000 will ask you whether you want to include the row or the column. Indicate your choice and click on OK.

Tip #714 applies to Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change.
 
Check out Word 2007 Styles and Templates today!