Excel Chart problem

%3CLINGO-SUB%20id%3D%22lingo-sub-922769%22%20slang%3D%22en-US%22%3EExcel%20Chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922769%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20make%20a%20chart%20out%20of%20the%20data%20below.%20What%20I%20want%20is%20row%20one%20to%20be%20the%20X%20axis%20then%20the%20low%20risk%2C%20high%20risk%2C%20etc.%20to%20be%20the%20Y%20axis.%26nbsp%3B%20In%20other%20words%2C%20I%20want%20row%20one%20to%20be%20at%20the%20bottom%20of%20the%20bar%20graph%20and%20bars%20to%20indicate%20the%20amount%20of%20high%20risk%2Flow%20risk.%20How%20do%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EUppercase%3C%2FTD%3E%3CTD%3ELowercase%3C%2FTD%3E%3CTD%3EUpper%20Sound%3C%2FTD%3E%3CTD%3ELower%20Sound%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3ESome%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3ELow%20Risk%3C%2FTD%3E%3CTD%3EHigh%20Risk%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-922769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I'm trying to make a chart out of the data below. What I want is row one to be the X axis then the low risk, high risk, etc. to be the Y axis.  In other words, I want row one to be at the bottom of the bar graph and bars to indicate the amount of high risk/low risk. How do I do that?

 

UppercaseLowercaseUpper SoundLower Sound2550
Low RiskLow RiskLow RiskLow RiskLow RiskHigh Risk
Low RiskLow RiskSome RiskSome RiskHigh RiskHigh Risk
Low RiskLow RiskSome RiskSome RiskLow RiskSome Risk
Low RiskLow RiskSome RiskSome RiskLow RiskHigh Risk
Low RiskLow RiskLow RiskLow RiskLow RiskSome Risk
Low RiskLow RiskLow RiskSome RiskHigh Risk 
Low RiskLow RiskLow RiskLow RiskSome RiskHigh Risk
Low RiskLow RiskHigh RiskHigh RiskHigh Risk0
Low RiskLow RiskSome RiskLow RiskHigh RiskHigh Risk
Low RiskLow RiskHigh RiskHigh RiskHigh Risk 
Low RiskLow RiskLow RiskLow RiskSome RiskSome Risk
Low RiskLow RiskLow RiskSome RiskSome RiskHigh Risk
Low RiskLow RiskLow RiskLow RiskLow RiskHigh Risk
Low RiskLow RiskLow RiskLow RiskLow RiskSome Risk
Low RiskLow RiskLow RiskLow RiskSome RiskHigh Risk
Low RiskLow RiskSome RiskSome RiskHigh Risk 
Low RiskLow RiskLow RiskLow RiskLow RiskHigh Risk
0 Replies