Thanks to Evan Ponter for a neat solution to this trending chart requirement over on the success community https://success.salesforce.com/answers?id=9063A0000019easQAA
Thank you for contacting me. I will get back to you as soon as possible.