Creating a bar and line chart together with only one name in the legend

%3CLINGO-SUB%20id%3D%22lingo-sub-1614644%22%20slang%3D%22en-US%22%3ECreating%20a%20bar%20and%20line%20chart%20together%20with%20only%20one%20name%20in%20the%20legend%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614644%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20line%20chart%20to%20show%20one%20point%20of%20data%20and%20a%20bar%20chart%20to%20show%20a%20different%20point%20of%20data.%26nbsp%3B%20I%20am%20looking%20to%20see%20if%20in%20the%20legend%20there%20is%20a%20way%20to%20only%20keep%20one%20location%20there%20as%20well%2C%20as%20every%20time%20I%20upload%20the%20information%20in%20a%20pivot%20table%20it%20creates%20two%20separate%20locations.%26nbsp%3B%20If%20there%20is%20something%20that%20anyone%20would%20need%20me%20to%20provide%20I%20gladly%20will%2C%20thanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1614644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615722%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20bar%20and%20line%20chart%20together%20with%20only%20one%20name%20in%20the%20legend%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F772449%22%20target%3D%22_blank%22%3E%40Duncan_Rogers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20of%20the%20sheets%20are%20you%20referring%20to%3F%20and%20which%20data%20set%20do%20you%20want%20to%20be%20a%20line%20graph%20and%20which%20one%20do%20you%20want%20to%20be%20a%20bar%20chart%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615772%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20bar%20and%20line%20chart%20together%20with%20only%20one%20name%20in%20the%20legend%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%20%22Runtime%20Copy%22%20is%20what%20I%20want%20it%20to%20look%20like%2C%20%22Runtime%20Percent%22%20is%20what%20it%20ends%20up%20looking%20like%20every%20time%20I%20try.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I am trying to create a line chart to show one point of data and a bar chart to show a different point of data.  I am looking to see if in the legend there is a way to only keep one location there as well, as every time I upload the information in a pivot table it creates two separate locations.  If there is something that anyone would need me to provide I gladly will, thanks for the help!

2 Replies

@Duncan_Rogers 

 

Which of the sheets are you referring to? and which data set do you want to be a line graph and which one do you want to be a bar chart?

 

Cheers

@wumolad 

 

Sheet "Runtime Copy" is what I want it to look like, "Runtime Percent" is what it ends up looking like every time I try.