Microsoft Office Tutorials and References
In Depth Information
Positioning Your Chart in a Workbook, Page, or Slide
Getting chart data from a table
(Word and PowerPoint)
Rather than painstakingly enter data in the data
grid, you can get the data you need for a chart
from a Word or PowerPoint table. In fact,
entering the data in a Word or PowerPoint table and
copying it to the data grid is easier than
entering data in the narrow confines of the data grid.
Follow these steps to generate a chart from data
in a table you created in Word or PowerPoint:
1. Click the table to select it.
2. On the (Table Tools) Layout tab, click the
Select button and choose Select Table on
the drop-down list.
3. Press Ctrl+C to copy the table data to the
4. Click your chart to select it.
5. On the (Chart Tools) Design tab, click the
Edit Data button to open the data grid.
6. Click in the cell in the first row, first
column of the data grid (cell A1).
7. Press Ctrl+V to copy the data from the
table into the data grid.
If the table you copied into the data grid is larger
than the sample data that was there before,
you’re done. You can breathe easy. But if the
table is smaller than the sample data, you have
to make the data range smaller so that it
encompasses only the data you copied from your table.
Move the pointer to the lower-right corner of the
data range and then drag in a northwesternly
direction until the blue box encloses the data
from your Word or PowerPoint table.
The data grid offers the Edit Data in Microsoft Excel button in case you want
to enter data for your chart in Excel. Click this button and enter data in Excel
if you’re comfortable working there.
In Word and PowerPoint, click the Edit Data button on the (Chart Tools)
Design tab at any time to open the data grid and fiddle with the numbers and
data from which your chart is generated.
Positioning Your Chart in a Workbook, Page, or Slide
To change the position of a chart, click to select it, click its perimeter, and
when you see the four-headed arrow, start dragging. Otherwise, follow these
instructions to land your chart where you want it to be:
Excel: To move your chart to a different worksheet or create a new
worksheet to hold your chart, go to the (Chart Tools) Design tab and
click the Move Chart button. You see the Move Chart dialog box.
• Tomoveyourcharttoadifferentworksheet,clicktheObjectInoption
button, choose the worksheet in the drop-down list, and click OK.
• Tocreateanewworksheetforachart,clicktheNewSheetoption
button, enter a name for the new worksheet, and click OK.
Search JabSto ::

Custom Search