SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2355238%22%20slang%3D%22en-US%22%3EHelp!%20How%20Do%20I%20Add%20Second%20Data%20Point%20to%20An%20Existing%20Graph%20in%20Excel%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355238%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I've%20spent%20much%20too%20much%20time%20trying%20to%20figure%20out%20how%20to%20add%20a%20second%20data%20point%20on%20a%20graph%20in%20Excel%20and%20thought%20I'd%20reach%20out.%20My%20data's%20not%20complicated%20whatsoever%20but%20apparently%20not%20structured%20in%20a%20way%20to%20follow%20the%20Help%20instructions.%20I've%20got%20a%202-D%20chart%20created%20(which%20is%20what%20they%20say%20more%20than%20one%20vertical%20axis%20requires)%20with%203%20years'%20worth%20of%20data%20plotted%20and%20am%20attempting%20to%20add%20a%20second%20line%20of%20data%20to%20plot%20on%20the%20vertical%20axis%20for%20the%20same%20timeframe.%20I'm%20sure%20it's%20easy%20as%20pie%20but%20it%20is%20excaping%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2355238%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355277%22%20slang%3D%22en-US%22%3ERE%3A%20Help!%20How%20Do%20I%20Add%20Second%20Data%20Point%20to%20An%20Existing%20Graph%20in%20Excel%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355277%22%20slang%3D%22en-US%22%3EA%20little%20more%20info...%20I%20just%20watched%20a%20brief%20vid%20on%20how%20to%20do%20this%20and%20on%20the%20'All%20Charts'%20tab%20in%20the%20'Change%20Chart%20Type'%20dialog%20box%2C%20when%20I%20select%20'Combo'%2C%20there's%20nothing%20for%20me%20to%20select.%20I%20can%20see%20the%20four%20chart%20types%20at%20the%20top%20of%20the%20dialog%20box%20but%20nothing%20in%20the%20actual%20box%20itself.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355310%22%20slang%3D%22en-US%22%3ERE%3A%20Help!%20How%20Do%20I%20Add%20Second%20Data%20Point%20to%20An%20Existing%20Graph%20in%20Excel%20Office%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054047%22%20target%3D%22_blank%22%3E%40DScrews1966%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20see%20something%20in%20the%20box%2C%20your%20chart%20needs%20to%20contain%20at%20least%20two%20series.%3C%2FP%3E%0A%3CP%3EFor%20a%20chart%20with%20only%20one%20series%2C%20%22combo%22%20makes%20no%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

9 Replies
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.
best response confirmed by allyreckerman (Microsoft)
Solution

@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.

@DScrews1966 

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...
My apologies, I only saw your last reply. Bless you! Trying it now...
Okay... so what version of Excel are you using? I ran into this w/all of the Help instructions as well... my ribbons don't match your instructions. I can find the functionality on the ribbon but not exactly as you outline and therefore not the same results.