Forum Discussion

DScrews1966's avatar
DScrews1966
Copper Contributor
May 14, 2021
Solved

Help! How Do I Add Second Data Point to An Existing Graph in Excel Office 365?

Hello! I've spent much too much time trying to figure out how to add a second data point on a graph in Excel and thought I'd reach out. My data's not complicated whatsoever but apparently not structu...
excel
  • HansVogelaar's avatar
    HansVogelaar
    May 14, 2021

    DScrews1966 

    Click on the chart.

    Activate the Design tab of the ribbon, under Chart Tools.

    Click 'Select Data' i the Data group.

    Under 'Legend Entries (Series)', click Add.

    Optionally, enter a name for the new series, or point to a cell containing that name.

    Then click in the 'Series Values' box, remove what's there, then point to the range containing the y-values for your second series.

    Finally, OK your way out.

HansVogelaar's avatar
HansVogelaar
MVP
May 14, 2021

DScrews1966 

Click on the chart.

Activate the Design tab of the ribbon, under Chart Tools.

Click 'Select Data' i the Data group.

Under 'Legend Entries (Series)', click Add.

Optionally, enter a name for the new series, or point to a cell containing that name.

Then click in the 'Series Values' box, remove what's there, then point to the range containing the y-values for your second series.

Finally, OK your way out.

Resources