Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to create a stacked bar chart in My qv document attached herewith. I want to to have two bar chart for Actual and budget.
In the each bar chart % of items give should appear. Pls help me to do this from QV document
Try this..
Total is now 100% because UPR has -3%
Thanks Manish
Slight change I do want to income to show in this chart. but how the % Income is divided among other items like
follows
CEDED | 970,000 | 18% |
UPR | 400,000 | 7% |
NET_CLAIMS | 2,000,000 | 37% |
ACQ_COST | 450,000 | 8% |
GROSS_PROFIT | 1,530,000 | 29% |
Pls help
I am not getting. Can you let me know exactly how you want to show % and what are the descriptions you are going to consider.
If possible, provide an excel with result. I will surely do my best to help you.
This is what I want
out of Total Income of 5,350,000
Ceded is 970,000 that is 18% of income (5350000)
UPR is 400,000 7% of income
Net Claim 2000000 37 %
....
Like wise total come to 100% .
Still you are not giving me full data..
.....
I will not understand what else DESCRIPTION you want to cover..
Kindly provide an excel..if possible
Also, UPR is -400,000 not 400,000. Please clarify !
Hi ,
If sum Budget = Total Income ( i.e, 5,350,000) for the below data
say if (970,000 + 400,000+2,000,000 + 450,000+1,530,000 = 5,350,000)
CEDED | 970,000 | 18% |
UPR | 400,000 | 7% |
NET_CLAIMS | 2,000,000 | 37% |
ACQ_COST | 450,000 | 8% |
GROSS_PROFIT | 1,530,000 | 29% |
then you can add one more expression =sum(Budget) and check relative checkbox, you will get the %age
Do you want this upaliwije ?
If yes, PFA.
Thanks
I have attached excel sheet. What I want is to show how Income is divided among other items
Sorry I could not attach excel sheet
Still you didn't clarify between -400,000 and 400,000