By adding data and updating the chart, data series may be added to charts.
A common feature among spreadsheet programs, such as Microsoft Excel, is the ability to add charts and graphs that illustrate your data. Basic charts, such as line, column and bar charts, typically translate your data into categories spread over two axes. By accessing the chart data and updating the chart, you may add a data series to a chart axis in spreadsheet programs. Many spreadsheet programs use a similar process to that of Microsoft Excel.
Instructions
- 1
Click the chart in Microsoft Excel to which you want to add a data series.
- 2
Click the “Design” tab on the “Chart Tools” ribbon and locate the “Data” group.
-
- 3
Click the “Select Data” icon, which will open a separate window.
- 4
Click the “Add” button in the “Legend Entries” section, which will open another window.
- 5
Type a name for the series in the “Series Name” field.
- 6
Click the “Collapse Dialog” button near the “Series Values” field.
- 7
Select the data that you want to use in the new series by clicking once on the first cell and drag to the last while holding down the mouse button.
- 8
Click the "Collapse Dialog" button again.
- 9
Click the “OK” buttons on the "Edit Series" and "Select Data Source" windows.
