May 14 2021 08:39 AM
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 structured in a way to follow the Help instructions. I've got a 2-D chart created (which is what they say more than one vertical axis requires) with 3 years' worth of data plotted and am attempting to add a second line of data to plot on the vertical axis for the same timeframe. I'm sure it's easy as pie but it is excaping
May 14 2021 08:47 AM
May 14 2021 08:50 AM
SolutionClick 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.
May 14 2021 08:53 AM
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.
May 14 2021 08:54 AM
May 14 2021 08:55 AM
See my first reply.
May 14 2021 08:56 AM
May 14 2021 08:59 AM
May 14 2021 09:02 AM
I'm using Excel 2019 on Windows 10.
May 14 2021 09:09 AM
May 14 2021 08:50 AM
SolutionClick 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.