Microsoft Office Tutorials and References
In Depth Information
Editing Chart Data
Editing Chart Data
You can edit chart data in a worksheet one cell at a time, or you can manipulate a range
of data. If you’re not sure what data to change to get the results you want, use the Edit
Data Source dialog box to help you. In previous versions, you were limited to 32,000 data
points in a data series for 2-D charts. Now you can have as much as your memory to store.
You can work with data ranges by series, either Legend or Horizontal. The Legend series
is the data range displayed on the axis with the legend, while the Horizontal series is the
data range displayed on the other axis. Use the Collapse Dialog button to temporarily min-
imize the dialog to select the data range you want. After you select your data, click the
Expand Dialog button to return back to the dialog box.
Edit Data in the Worksheet
In the worksheet, use any of the following methods to edit cell contents:
• To replace the cell contents, click the cell, type the data you want to enter in
the cell. It replaces the previous entry.
• To edit the cell content, double-click the selected cell where you want to
edit.
Press Delete or Backspace to delete one character at a time, and then type the
new data.
Press Enter to move the insertion point down one row or press Tab to move the
insertion point right to the next cell.
Search JabSto ::




Custom Search