Excel Formulas to Show as Percentage Based Graphs

%3CLINGO-SUB%20id%3D%22lingo-sub-1490867%22%20slang%3D%22en-US%22%3EExcel%20Formulas%20to%20Show%20as%20Percentage%20Based%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490867%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20the%20Chief%20Resident%20at%20OSU%20for%20Family%20Medicine%20and%20I%20am%20utilizing%20Excel%20to%20formulate%20our%20Didactic%20Curriculum.%20Wondering%20how%20to%20configure%20data%20to%20certain%20cells%20so%20on%20my%20Analytics%20Sheet%20the%20data%20will%20be%20extrapolated%20as%20a%20percentage%20based%20bar%20graph%3F%3C%2FP%3E%3CP%3EMedicine%20has%20various%20topics%20Cardiology%2C%20Pulmonology%2C%20Gastroenterology.%20Those%20topics%20are%20incorporated%20throughout%20various%20domains%20such%20as%20Hospital%20Medicine%2C%20Ambulatory%20Medicine%2C%20Pediatric%20Medicine.%20I%20want%20to%20tag%20various%20topics%20(card%2C%20pull%2C%20GI)%20across%20each%20domain%20(Hosp%2C%20Amb%2C%20Peds)%20so%20on%20my%20analytics%20page%20it%20will%20show%20(based%20on%20how%20many%20lecture%20topics%20I%20have)%20what%20percentage%20of%20those%20lectures%20are%20Cardiology%2C%20Pulmonology%2C%20GI%20etc.%20In%20the%20example%20below%20cell%20B263%20is%20a%20cardiology%20lecture%20while%20cell%20B269%20is%20a%20pulmonology%20lecture%20(all%20within%20Pediatrics).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!!!!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bdockery_1-1593127145896.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201233i2DEC595C73417FBB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22bdockery_1-1593127145896.png%22%20alt%3D%22bdockery_1-1593127145896.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%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1490867%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491841%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20to%20Show%20as%20Percentage%20Based%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710684%22%20target%3D%22_blank%22%3E%40bdockery%3C%2FA%3E%26nbsp%3BHey%20Can%20you%20send%20the%20excel%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494140%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20to%20Show%20as%20Percentage%20Based%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%26nbsp%3BMy%20apologies%20for%20the%20late%20reply.%20Definitely%20can%20send%20the%20file.%20It's%20not%20fully%20completed%20as%20the%20residents%20will%20sign%20up%20for%20individual%20slots%20based%20on%20the%20topics%20I've%20selected.%20Once%20signed%20up%20I%20will%20attach%20data%20then%20so%20I%20can%20see%20what%20percentage%20of%20information%20we%20are%20covering%20and%20if%20that%20correlates%20to%20what%20we%20should%20be%20covering%20(ex.%2018%25%20of%20didactic%20content%20might%20be%20cardio%20when%20it%20should%20really%20be%2010%25%2C%20thus%20we%20should%20inform%20residents%20to%20choose%20less%20cardio%20material%20to%20teach%20during%20didactics).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494155%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20to%20Show%20as%20Percentage%20Based%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710684%22%20target%3D%22_blank%22%3E%40bdockery%3C%2FA%3E%26nbsp%3BRead%20the%20private%20message%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I'm the Chief Resident at OSU for Family Medicine and I am utilizing Excel to formulate our Didactic Curriculum. Wondering how to configure data to certain cells so on my Analytics Sheet the data will be extrapolated as a percentage based bar graph?

Medicine has various topics Cardiology, Pulmonology, Gastroenterology. Those topics are incorporated throughout various domains such as Hospital Medicine, Ambulatory Medicine, Pediatric Medicine. I want to tag various topics (card, pull, GI) across each domain (Hosp, Amb, Peds) so on my analytics page it will show (based on how many lecture topics I have) what percentage of those lectures are Cardiology, Pulmonology, GI etc. In the example below cell B263 is a cardiology lecture while cell B269 is a pulmonology lecture (all within Pediatrics). 

 

Thank you!!!!!!

bdockery_1-1593127145896.png

 

 

 

3 Replies

@bdockery Hey Can you send the excel file.

@DevendraJain My apologies for the late reply. Definitely can send the file. It's not fully completed as the residents will sign up for individual slots based on the topics I've selected. Once signed up I will attach data then so I can see what percentage of information we are covering and if that correlates to what we should be covering (ex. 18% of didactic content might be cardio when it should really be 10%, thus we should inform residents to choose less cardio material to teach during didactics).

 

 

@bdockery Read the private message