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 minimize the dialog to select the data range you want. After you select your data, click the Expand Dialog button ...

Get Word 2013 on Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.