This content has been marked as final.
Show 3 replies

1. Re: How to calculate ratio for bar graph?
Prashant Sharma Jul 22, 2014 10:14 PM (in response to Ganesh K)Hi Ganesh,
Use % of Total from Quick Table Calculation & compute it using Date Season.
Warm Regards,

2. Re: How to calculate ratio for bar graph?
Ganesh K Jul 22, 2014 10:18 PM (in response to Prashant Sharma)Hi Prashant,
Thanks for reply, Is that possible to have "Ratio" instead of percentage like this"2:1"?

3. Re: How to calculate ratio for bar graph?
Prashant Sharma Jul 22, 2014 11:23 PM (in response to Ganesh K)1 of 1 people found this helpfulHi Ganesh,
Showing this chart in form of ratio is not a good approach because you are calculating sales ratio here. But if you want to show approx ratio then we can calculate it but showing exact ratio is not good for many purposes over here. Like if you have sales of around 106943 for dry season & 395737 for rainy season & if both are not divisible then you can't find an exact ratio between these two. Showing this as %age is the best option.
Warm Regards,