Percentage Chart

[sahm24]

Hi All,

I am currently in the process to developing a financial dashboard. I have debtors column chart by month. I also want to show the ageing balance on the same chart. For example the line for November would be split into three colors based on percentage of 30days/60days & 90 days. Is this even possible?

Thanks in advance for the help.

 

[svendiamond]

Going to need some more information to help you out. Try being more specific...

 

[sahm24]

Going to need some more information to help you out. Try being more specific...

For example if my total debtor balance for the month is $1000 and 50% is withing <30days 30% is <60days and 20%>6odays. I want the column chart of November to show total debtor is $1000 and side that column it will split by percentage as above in different color with the percentage amount showing inside each color block.
___
l 50 l
l_ l
l 30 l
l___l
l l
l_20l
Nov'14



Hope it makes sense above diagram makes sense.