Clustered Bar Graph With Line as %

[Anonymous]

Hello,

I am trying to put a line on clustered column and line chart. My goal is to have my releases/outstandings by month which will be the percent that I am plotting. I cannot get it to exactly cooperate with me. My data has dealers, releases and outstanding in that order for columns. So getting a monthly percentage is challenging. I cannot figure out how to attach the file to this so here is a table for reference.

Thank you in advance!

Dealer NamePeriod DateTotal ReleasesBeginning of Period OutstandingsLiquidations %

Dealer 1	8/31/2018	0	0	0
Dealer 2	8/31/2018	0	84381	0
Dealer 3	8/31/2018	0	0	0
Dealer 4	8/31/2018	0	0	0
Dealer 5	8/31/2018	105927.34	686362.7	15.43
Dealer 6	8/31/2018	1335574.99	3886487.51	34.36
Dealer 7	8/31/2018	365749.56	1304146.72	28.05
Dealer 8	8/31/2018	67268.87	1179016.5	5.71
Dealer 9	8/31/2018	0	942138	0
Dealer 10	8/31/2018	374737.3	472354.74	79.33

[HotChilli]

I think you'll have to explain in more detail what you're having difficulty with.

Have you got the percentage worked out already (the last column in your table) but you can't get it on the chart?

It would look like this (ignore the order of the x-axis)

or is there a problem getting a monthly percentage?  I would think the real data is also a bit more complex.

If you explain further, someone will help out.