SOLVED

Limited Series on Line graph?

%3CLINGO-SUB%20id%3D%22lingo-sub-3299660%22%20slang%3D%22en-US%22%3ELimited%20Series%20on%20Line%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299660%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20a%20line%20graph%20with%204%20series%20but%20excel%20is%20only%20recognising%203%20of%20them%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20deselecting%20and%20selecting%20the%20data%20from%20the%20chart%20design%20tab%2C%20and%20just%20adding%20the%20series%20it%20doesn't%20recognise%20but%20still%20doesn't%20work.%20But%20in%20my%20legend%20for%20the%20line%20graph%2C%20it%20says%20it%20has%20included%20it%3F%20Would%20really%20appreciate%20the%20help!%20Thanks%20in%20advance!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pq4zzo_0-1651387650816.png%22%20style%3D%22width%3A%20742px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368264i4A14E0A94534D455%2Fimage-dimensions%2F742x291%3Fv%3Dv2%22%20width%3D%22742%22%20height%3D%22291%22%20role%3D%22button%22%20title%3D%22pq4zzo_0-1651387650816.png%22%20alt%3D%22pq4zzo_0-1651387650816.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pq4zzo_1-1651387739361.png%22%20style%3D%22width%3A%20420px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368265iEBFD8885C43FF69A%2Fimage-dimensions%2F420x235%3Fv%3Dv2%22%20width%3D%22420%22%20height%3D%22235%22%20role%3D%22button%22%20title%3D%22pq4zzo_1-1651387739361.png%22%20alt%3D%22pq4zzo_1-1651387739361.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3299660%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299715%22%20slang%3D%22en-US%22%3ERe%3A%20Limited%20Series%20on%20Line%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299715%22%20slang%3D%22en-US%22%3EThank%20you!%20I've%20just%20realised%20from%20your%20comment%20that%20I've%20put%20in%20the%20same%20data%20twice%20aha.%20Again%20thanks%20so%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299668%22%20slang%3D%22en-US%22%3ERe%3A%20Limited%20Series%20on%20Line%20graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1378023%22%20target%3D%22_blank%22%3E%40pq4zzo%3C%2FA%3E%26nbsp%3BIt%20seems%20the%20the%20data%20for%20the%20blue%20line%20exactly%20matches%20the%20data%20for%20the%20grey%20line.%20The%20blue%20line%20is%20merely%20%22hiding%22%20behind%20the%20grey%20line.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

I'm trying to make a line graph with 4 series but excel is only recognising 3 of them? 

I have tried deselecting and selecting the data from the chart design tab, and just adding the series it doesn't recognise but still doesn't work. But in my legend for the line graph, it says it has included it? Would really appreciate the help! Thanks in advance!

pq4zzo_0-1651387650816.png

 

pq4zzo_1-1651387739361.png

 

 

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@pq4zzo It seems the the data for the blue line exactly matches the data for the grey line. The blue line is merely "hiding" behind the grey line.

Thank you! I've just realised from your comment that I've put in the same data twice aha. Again thanks so much.