Hello Gary

Thank you for your purchase.

If I understood correctly, the data in the table is fine, but it's not coming out fine in the chart?

If that's true, that's because chart engines do not inherit number format from wpDataTables.

To change the format, you will need to use 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 Support help center). 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 certain level of programming skills and included support refers only to advice.

Take a look at this page in our FAQ section - it shows how you can change the format.

I can take a look at your table and your chart, but I doubt there's a solution to this other than using the callback.

Chart engines we use (they're not ours) do not inherit the number format from wpDataTables, so if your table is showing the correct format, and it breaks or displays a different format in the chart - you need to change the format using callbacks.

Tell me what are the table's and the chart's IDs and I'll take a look.

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. 

You can write credentials here just check Private Reply so nobody can see them except us.

Hey Gary

You need to configure the number format in wpDataTables to be the same as it is in Excel.

Since the decimal separator in Excel is a point, not a comma, and due to the fact that you have 3 decimal places in there, you need to set up the same format in wpDataTables settings:

After that, it should work fine.

You're welcome Gary

Glad I could be of service

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.