Possible? Variable X and Y data sources and Auto Charting

J

JQuinn

Thank you in advance for any help/insights. Is it possible to create an Excel template that can automatically chart Likert data with variable conditions along X and Y axis, from one report to the next? Please note, I have little understanding of Excel.

Ultimately, I would want the following functionality.

1. Variable number of Likert Questions from one report to the next.
I see that each Question could have its own Sheet. Question placed in Cell A1.

2. Variable Likert Scale from one report to the next.
I see that the scale could include 2-10 options, depending on the question.
These options could be listed across Row 2.

3. Variable number of groups responding from one report to the next.
I see listing different groups in Column A. 1-100+ groups.

4. Auto-chart responses where axis feature each Group and their percentage response to each Likert Scale choice. Also, perhaps auto insert Chart on separate Chart Tab to follow related Sheet/Question.

Examples:

Report 1 / Sheet 1 / Chart 1
Likert Question 1: Do you like your job?
Likert Scale: Yes, Neutral, No
Group: 50% Yes, 40% Neutral, 10% No
Women: 60% Yes, 20% Neutral, 20% No
Men: 80% Yes, 5% Neutral, 15% No

Report 2 / Sheet 1 / Chart 1
Likert Question 1: Are we having fun yet?
Likert Scale: Strongly agree, Agree, Neutral, Disagree, Strongly Disagree
Group: 20% SA, 20% A, 20% N, 20% D, 20% SD
Women: 15% SA, 25% A, 10% N, 30% D, 20% SD
Men: 10% SA, 30% A, 40% N, 10% D, 10% SD
Children: 60% SA, 20% A, 5% N, 10% D, 5% SD

Report 2/ Sheet 2 / Chart 2
Likert Question 2: Do we need more ice cream?
Likert Scale: Yes, No
Group: 95% Yes, 5% No
Women: 80% Yes, 20% No
Men: 98% Yes, 2% No
Children: 99% Yes, 1% No
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top