Graphs-formula to use

AnaFab

New Member
Joined
Nov 13, 2023
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hi
I would really appreciate some help as my knowledge in excel is basic.
I have created a questionnaire with 11 questions and this will be completed at 2 different times with each person, once pre and once post intervention.
The achieves for each question are 1 to 10. When I get the results, I am aiming to see if the scores have improved post intervention. Now, I can do graphs that show the scores for each question but what I really want to show is that how many people (in percentage) showed an increase in each question post intervention. Does that make sense? So rather than the total scores, say 80% of people show an improvement in family life post intervention (as question 1 in time 2 were greater scores than in time 1). I hope that makes sense
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
i think this is what you're asking for, if not let me know...
in line 14 it's showing % of each person that increased from time 1 to time 2 for each question
----------------
Book1
ABCDEFGHIJKLMNOPQRSTUVW
1personquestion 1 time 1question 1 time 2question 2 time 1question 2 time 2question 3 time 1question 3 time 2question 4 time 1question 4 time 2question 5 time 1question 5 time 2question 6 time 1question 6 time 2question 7 time 1question 7 time 2question 8 time 1question 8 time 2question 9 time 1question 9 time 2question 10 time 1question 10 time 2question 11 time 1question 11 time 2
2person 156165458481438476521064
3person 236410193666485536465658
4person 331045342659183729162448
5person 42437610283664284757310710
6person 5210371754186645175741067
7person 64464191829154868271965
8person 74921016262641065682739610
9person 81102634410376102851049210710
10person 9685951067244469446104668
11person 10653531034575847410683978
12
13question 1question 2question 3question 4question 5question 6question 7question 8question 9question 10question 11
1480%90%90%90%90%70%80%90%90%100%80%
Sheet1
Cell Formulas
RangeFormula
B14,V14,T14,R14,P14,N14,L14,J14,H14,F14,D14B14=COUNTA(FILTER($A$2:$A$11,C2:C11>B2:B11))/COUNTA($A$2:$A$11)
 
Upvote 0
i think this is what you're asking for, if not let me know...
in line 14 it's showing % of each person that increased from time 1 to time 2 for each question
----------------
Book1
ABCDEFGHIJKLMNOPQRSTUVW
1personquestion 1 time 1question 1 time 2question 2 time 1question 2 time 2question 3 time 1question 3 time 2question 4 time 1question 4 time 2question 5 time 1question 5 time 2question 6 time 1question 6 time 2question 7 time 1question 7 time 2question 8 time 1question 8 time 2question 9 time 1question 9 time 2question 10 time 1question 10 time 2question 11 time 1question 11 time 2
2person 156165458481438476521064
3person 236410193666485536465658
4person 331045342659183729162448
5person 42437610283664284757310710
6person 5210371754186645175741067
7person 64464191829154868271965
8person 74921016262641065682739610
9person 81102634410376102851049210710
10person 9685951067244469446104668
11person 10653531034575847410683978
12
13question 1question 2question 3question 4question 5question 6question 7question 8question 9question 10question 11
1480%90%90%90%90%70%80%90%90%100%80%
Sheet1
Cell Formulas
RangeFormula
B14,V14,T14,R14,P14,N14,L14,J14,H14,F14,D14B14=COUNTA(FILTER($A$2:$A$11,C2:C11>B2:B11))/COUNTA($A$2:$A$11)
I think this is it!! I shall try! Thank you 🙏🏽
 
Upvote 0
happy to help, lemme know if it works for your needs
 
Upvote 0
Hi. Thank you so much for your support. It’s not quite working as I wanted but so close. What could I be doing wrong?
 
Upvote 0
can you share a sample to see what you're working with?
suggest using xl2bb plugin, link below
 
Upvote 0
can you share a sample to see what you're working with?
suggest using xl2bb plugin, link below
Excel Formula:
I am struggling to do this. I will ask for help later in the day to see if I can upload it. Thank you for your patience and time.
 
Upvote 0
My work does not allow me to download xl2bb. I will see if I can borrow a laptop to do this. So frustrating. Thank you for your help
 
Upvote 0

Forum statistics

Threads
1,223,240
Messages
6,170,951
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top