Hi Juan,

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.

-

If i understood the main issue, it is not being able to change the Number Format, how it gets loaded in the Chart, right?

Chart engines do not inherit the number format you set up in wpDataTables, and there are no built-in options to change the number format in the chart, but you can use wpdatachart callbacks. 

Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization.

For example, you can take a look at this example and see how we changed the number format in HighCharts.

Please note that using wpDataChart or wpDataTables callbacks requires a certain level of programming skills, and included support refers only to advice.

I hope that helps.

Hi Juan,

As we mentioned before - This is not an issue coming from our Plugin, but it is the default behaviour how all Charts work.

The Charts do not follow the Number Format or the decimal points as they come from the Source Table by default.

I am sorry to see that the link we sent earlier no longer works/ i am going to edit that response for the future, thank you for pointing that out.

We will elaborate in more details in regards to what you can try to achieve a different Number Format on your Charts.  ( same goes for decimal points)

Chart engines do not inherit the number format you set up in wpDataTables, and there are no built-in options to change the number format in the chart.

The only way you can try to change a Number Format on a Chart is by a Custom Chart Callback.

Every chart engine has its own layout and its settings.

We use free libraries for chart engines, and they are limited as to what we can change from within the plugin's UI.

You can check out all the available chart engines and examples of wpDataCharts documentation here . 

If the options you need are not in the chart creation wizard,  you can try to find a custom solution using chart callbacks.

You can check our documentation about wpDataCharts callbacks. 

On that Page, you will see one custom callback example for each Chart Engine, made by our Developers.

We will work to add more examples like that, but we can't say an exact ETA.

For Apex Charts, please check under the section called :

ApexCharts
An example of using hooks for ApexCharts.js

You will need to modify that example to change the options you need for the Chart.

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

Hi Juan,

1.Your answer is that the plugin you sell to move data from a table to a chart, does not correctly pick up the data from that table, correct? 

 Also you are telling me that this is not a bug, but a feature.

-

We are simply stating this as one of our current limitations when it comes to 'out of the box' settings for Charts.

Our Table is going to pass the numbers, but as mentioned, the Chart engines we use do not inherit the Number Format which is set from our Plugin end, instead the Charts use their default Number Format.

At the moment, we do not have any 'out of the box' option/setting from the Chart Wizard which would enable you to change the Number Format on the Charts.

For a native option like that, you can create a development suggestion and our devs will do their best to work on that in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

This is the way how we handle the current limitations, for example if any option is not available at the moment, we take feedback and suggestions from our users - then our developers work on adding the improvement or needed feature during Updates.

But when something is not possible right now, then we can only propose an example if we have it, or to suggest on possible ways what you could try if you have coding skills.

Other than that, our Support does not cover Custom work.

As mentioned, It is possible to achieve this now with a Custom Chart Callback to change the Number Format on Charts.

-

2. In regards to that link not working, with our example of changing the Number Format for HighCharts Engine;

My apologies, we somehow missed that Page after our latest update, did not double-check it, we got a cache issue on it right now.

I will notify our SEO Team to clear the cache on this page and will let you know as soon as they do that, then it will  start working again - they have finished their work for today, but within the next 20 hours or less this will be fixed and you will be able to check out our developer's example how to change the Number Format for HighCharts.

We will do our best to create an example for other Chart Engines in the future in regards to a custom Chart Callback which can change the Number Format.

As soon as the Page for the HighChart example is fixed, i will report back to let you know.

Thank you for your patience.

Hi Juan,

We fixed the issue we had on that example Page.

1. Please check out this example our developers made for the HighCharts Engine, where they used this custom wpDataCharts callback to change the decimal separator and the number of decimals on the Chart's Number Format.

2. When it comes to ApexChart callback examples,  at the moment we only have that one, of how to change the colors on a Pie Chart, from this Page, under "

ApexCharts
An example of using hooks for ApexCharts.js

"

I realise this is not the specific example you need of how to change the Number Format, such as decimal separator and number of decimals on the Chart, but right now we don't have that example for ApexCharts yet.

I will do my best to work something our with our QA team and the Developers to add a specific example of changing the Number Format for ApexCharts as soon as possible, we just can't promise an exact ETA on it.

-

For now, we have that HighChart example how to change the Number Format;

Then, for the ApexCharts you can see how the syntax of the code should be for changing the color of a Pie Chart, and then try to find the right option to edit our example according to your use-case.

As it shows, this is the syntax for changing the option of colors for an Apex Pie Chart :

<script type="text/javascript">
jQuery(window).on('load',function(){ 
    if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; } 
    wpDataChartsCallbacks[40] = function(obj){ 
        obj.options.colors = ['#2E93fA', '#66DA26', '#546E7A', '#E91E63', '#FF9800', '#FFF800','#570A57','#000','#FFE3A9','#FFC3C3','FF5D5D'];
    }
});
</script>

You can find available options at ApexCharts.js API Reference.

When you find the right option(s) for manipulating the Number Format there, you can edit our example, change the Chart ID to your Chart ID, and change what is written inside the main brackets for the option, to the option(s) you need.

Also, when you add a script like that, it is best to add it directly to your WP Page where you have the Chart, as a Custom HTML block.

There is another way, you can remove the "<script> ... </script>" tags from around the JS code, and add it to our Main Plugin settings/Custom Js and CSS/Custom CSS;

or as Custom JS to your WP - but in some cases, depending on the combination of Plugins and Security Settings on Hosting, this can get blocked;

so the most effective way is to add it as the script directly to the WP Page.

-

If we find more useful details, of which specific option you need for the Apex Number Format, we will return and going to share that with you, or if we add the specific example, i will also report back to notify you and to pass the link.

For now, that is the best we have, to try to point you in the right direction, until we add a more specific example with our devs soon.

I hope it helps.