Population Pyramid

%3CLINGO-SUB%20id%3D%22lingo-sub-3217103%22%20slang%3D%22en-US%22%3EPopulation%20Pyramid%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217103%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBrand%20new%20to%20this%20Discussion%20Board%20but%20have%20a%20question%20regarding%20population%20Pyramids%20on%20Excel%20Spreadsheet.%20I%20am%20able%20to%20find%20the%20correct%202D%20Bar%20graph%20as%20I%20have%20been%20told%20you%20can%20compromise%20to%20a%20Population%20Pyramid%20once%20the%20data%20is%20put%20in%20place.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20that%20I'm%20unable%20to%20transfer%20the%20data%20from%20the%20spreadsheet%20to%20the%20bar%20graph.%20I%20have%20told%20to%20make%20one%20of%20the%20axis%20negative%20in%20which%20I%20did%20but%20other%20than%20that%2C%20I'm%20unsure%20of%20how%20to%20go%20about%20this.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3EThxs%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAidan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217140%22%20slang%3D%22en-US%22%3ERe%3A%20Population%20Pyramid%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318696%22%20target%3D%22_blank%22%3E%40Aidan_Jackson410%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F2137-excel-population-pyramid.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20create%20population%20pyramid%20chart%20in%20Excel%3F%3C%2FA%3E%20for%20illustrated%20step-by-step%20instructions%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey Guys,

 

Brand new to this Discussion Board but have a question regarding population Pyramids on Excel Spreadsheet. I am able to find the correct 2D Bar graph as I have been told you can compromise to a Population Pyramid once the data is put in place. 

 

My issue is that I'm unable to transfer the data from the spreadsheet to the bar graph. I have told to make one of the axis negative in which I did but other than that, I'm unsure of how to go about this.

Any help would be appreciated. 

Thxs

 

Aidan

1 Reply

@Aidan_Jackson410 

See How to create population pyramid chart in Excel? for illustrated step-by-step instructions