Hi Joe,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I presume your desired look of the Chart will be as on the Excel you send, like on the screenshot?

Can i please check how you configured your Chart at the back-end,

and if you can check is this the right URL for the front-end Page, 

i am not seeing any Chart here?

Please provide me a temporary WP-admin (administrator) user 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 parties. 

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

And double-check the URL of the Page where you have the Chart, so i can check it;

Also if you can confirm the Chart ID, so i can see it at the back-end setup.

Thanks.

Hi Joe,

My apologies for all the waiting time.

I found what the issues are, and will advise you.

1. In regards to the decimal Points,  when you import Excel to make a new Manual table in your Database,

you have the option to choose the individual Decimal place for each Column.

So if you choose "decimal" for example for a Float Column, make sure to select this Type Value,

and set this number after the "16" to be the number of decimals you need,

in this case set as "16,1".

This should solve the issue with decimals in Imported/Manual Tables.

2. I notice the Number Format seems to be different when i compare the Excel you sent me.

In the excel file, it seems the numbers have the dot as the decimal separator, such as :

3.7

8.1

11.3

and so on,  which means in the Plugin you should choose the other Number Format in the Main Settings.

I changed it for you now, this will be applied for New Tables, so let me know if the numbers look better if you try to import a new Excel Table.

3. In regards to passing the percentage sign to the Charts as suffix/or prefix,

This can't be inherited from the table's prefix or suffix, so you will need to use wpDataCharts callbacks to display the percentage.

Take a look at this page, where we explained how this can be added on a chart with two Y axes. The same logic applies to one axis.

• 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.