I am very new in QV. Please help me like a newby to create the following desired chart result which is very easy in Excel but i have no idea how to do it in QV.
The main data sheet is as below:
User Status
Uptill_Dec
Uptill_Jan11
Uptill_Feb11
In Production
1
1
1
In Production
1
0
1
In Production
1
0
0
Not in Production
1
1
1
In Production
1
1
0
In Production
1
0
0
In Production
1
1
0
In Production
0
1
1
Not in Production
0
1
1
In Production
1
1
1
In Production
1
1
0
Not in Production
1
1
1
first I have to calculate percentage like below:
User status
Uptill_Dec
Uptill_Jan11
Uptill_Feb11
In Production
83.33%
75%
58.33%
Not in Production
16.67%
25%
41.67%
Then have to represent it in line chart as attached.
