Forum Discussion
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...
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.
A little more info... I just watched a brief vid on how to do this and on the 'All Charts' tab in the 'Change Chart Type' dialog box, when I select 'Combo', there's nothing for me to select. I can see the four chart types at the top of the dialog box but nothing in the actual box itself.
To see something in the box, your chart needs to contain at least two series.
For a chart with only one series, "combo" makes no sense.
- I'm attempting to add a second data series...
See my first reply.
- My apologies, I only saw your last reply. Bless you! Trying it now...