Microsoft Graph reserves the first row and column of the datasheet for text that identifies the information in that row or column. In the case of an xy (scatter) or bubble chart, the first row or column contains values.
-
Switch to the datasheet.
How?
-
Click a cell, and then type the text or numbers you want.
Note: If you change existing text or values, the chart changes to reflect the new text or values.
Datasheet options
You can change datasheet options to move cell selection to the next cell once you press Enter or enable drag-and-drop to copy cell data to other cells. To do that:
-
Simply click anywhere in the datasheet.
-
On the Tools menu, click Options.
-
In the Datasheet Options tab, select any of the following options:
Move selection after Enter Selecting this option will make the adjacent cell the next active cell after your press ENTER in the current cell.
Cell drag and drop Select this check box to move and to copy cells and data by dragging.
