October 19, 2016
Thanks for all the interesting topics and tips & tricks already found here.
At the moment I'm having a question for which I haven't found a solution just yet.
example: I have a list of customers with their spent per month (customers in rows, spend per month in columns). I have added sparklines as an extra column, line sparkline, so it is easy to see the evolution in the customer spent. I have also added negative in red so this gets the attention as well.
But I was wondering whether it is also possible to add a trendline to a sparkline, so you can see the trend in this one-cell graph.
Thanks in advance for your help,
April 21, 2015
June 25, 2016
I don't think you can add a trendline to a sparkline unless you fake it. Even if you managed to do that, the sparkline will be very difficult to read. You can see an example here https://alesandrab.wordpress.com/2013/12/13/stackable-sparklines/
In your scenario, I would fake a sparkline using a normal chart. I have created 2 series of line charts, one with a trendline and the other with markers only (line hidden) for displaying negative value markers. I have hidden all the chart elements except the lines and markers.
See my example attached.
Hope this helps.
Most Users Ever Online: 57
Currently Online: Mynda Treacy
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas