How to set up data for a column graph

[hking]

hello,

I have 3 factors in my data: 12 competencies, each with percentages. I would like to put these competencies into a column graph, with a legend that is color-coded for "high," "mid," and "low" percentages.

I have tried several different ways to set up the data, but none of them are creating a column graphs with columns for each competency, and color-coded according to which group it falls in.

Any help?~

 

[shemayisroel]

Hi hking & Welcome,

I think what you're looking for is conditional chartting, refer to below for a step by step instruction on how to achieve it.

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Let me know how you go.