Show All

Work with a data sheet

If you created your chart by typing data into a data sheet, you can use these procedures to work with data sheets.

1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. On the toolbar, click Commands and Options , and then click the General tab.
3. Under General commands, click Chart Workspace in the Select list.
4. Click the Data Sheet tab.
5. Do one or more of the following:

   Enter data

   Note  You can enter category or series labels in the first column or first row of the data sheet.

   1. Select a cell in the data sheet.
   2. Type the data you want to enter in the cell.
   3. Press ENTER to enter the data and move the cell selection down, or press the TAB key to enter the data and move the cell selection to the right.

   Clear the data sheet

   • Click Clear Data Sheet .

   All data is cleared from the data sheet and from the chart. This action cannot be undone.

   Change category rows to series rows, or series rows to category rows

   • Click By Row - By Column .

   Copy and paste data

   1. Select the data you want to copy, either in the data sheet or in another program.
   2. Click Copy .
   3. Select the cell in the upper-left corner of where you want to paste the data.
   4. Click Paste .

   Note  Pasted data will overwrite existing content in cells.