Hi, John.
TeamDesk graphs are good & simple to set up, but the options are limited.
When I find myself in need of a graph that can't be done in TeamDesk, I use a third-party service. My service of choice is quickchart.io. They have quite an extensive chart gallery, & the service works very well. With quickchart.io, you have total control over colors.
Of course, setting up charts with quickchart.io is much more laborious, but once you have a chart set up the way you like it, it works like a charm.
Basically, this is how you do it:
1) You set up a Formula-URL column with the URL address of quickchart.io & your chart parameters, something like this (of course, in the formula you replace these figures with column values from your database):
https://quickchart.io/chart?c={type:'bar',data:{labels:['Q1','Q2','Q3','Q4'], datasets:[{label:'Users',data:[50,60,70,180]},{label:'Revenue',data:[100,200,300,400]}]}}
2) You set up a Formula-XHTML column with an <img> tag that references the Formula-URL column.
And that's it, you are all set. You can include the Formula-XHTML column in forms, views & documents.
If you want to try it & need help, just reach out to me (jsolaullod@gmail.com).
