Hi Edwin,

thank you for reaching out to us

That is the default behavior of the charts engine, but if you need some custom solution you can check our documentation about wpDataCharts callbacks. 

• Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API. 

• All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
• Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.

Hello Edwin

What you're asking to do would be rather cumbersome, but I assume you can do it.

You would need to create a new chart for every row manually, and when you get to the Data Range step:

You need to enable the "Pick Range":

Then click on the Range picker, and select only the first row. Save the chart and go to wpDataTables settings. Make sure "Parse shortcodes in strings" is enabled and then paste the shortcode of the first chart into the designated column of the table.

Then repeat the procedure for all other rows. There's no way to automate this, I'm afraid.

Hi again Edwin

Sorry for the late response.

If you're not on a shared hosting, it shouldn't be causing issues. I prefer Highcharts, but there's no specific reason, to be honest. Google Charts are the heaviest, I believe, and they have a lot of padding around them, so I definitely wouldn't recommend using them.

You can create a table, and add the shortcodes for the charts in their specific column. Then, when you make all charts from that table, they would automatically populate, since the string would be pulled from Google Sheets. Since you're using the API, it'd be faster.

Hi Edwin

Thank you for reaching out to us. Aleksandar is no longer working on this case so let me forward it to him as he will be more suitable to assist in this matter.

We appreciate your time and patience.

Please note: due to COVID-19 our team has been short on staff, so it may take a bit longer than usual to receive a response, but we are doing our best to provide assistance as fast as possible, thank you for your understanding.

Hello again Edwin

wpDataTables can't pull any formatting, styles, formulae, etc. from external sources (Google Spreadsheets, Excel, CSV, etc.), so pulling that sparkline would not be possible.

I'm afraid there's no workaround for this at the moment.