Forum Discussion
Clustered Bar Graph With Line as %
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 |
1 Reply
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.
