Hi Jonna,

The unavailable column type from the Starter licence, which you see as 'starred out', it is the Hidden/Dynamic column type.

That will not be useful for your use-case here, to have the numeric column as currency.

You can read more details on what the Hidden/Dynamic column type can be used here.

But I digress, back to the main issue and how you can achieve having the currency data in your Table :

Can you tell me do you have any symbols inside the cells where your numeric data is,

for example a currency sign?

If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.

The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Google Sheet,

then you can make integer or Float Column from this in our connected Table.

 ( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)

After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.

Let me know if that helps.

Thank you.

Hi Jonna,

1. I am glad to see you managed to fix that initial issue, great! :)
   
   
   
2. In regards to chart customizations - 
   
   I will advise you in general, everything about customizing the Charts, I hope this helps :
   

   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. 

   • 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.
   
   
   I hope that helps.
   Let me know if you tried something specific and if it does not work as expected.

Hi Jonna,

My apologies, now when I see the screenshots, I realise you just meant to set the custom colors on the charts series.
At this time, we found a new bug for all our charts.
This bug only happens with the latest 6.7.1 version.

The custom colors are not getting saved when we change them on the chart series.

 

Our developers isolated the bug, and they'll add it to their queue for fixing.

 They will do their best to build a fix as soon as possible.

 It should be finished very soon, but we don't have an exact ETA, so please keep a lookout on our wpDataTables changeLog.

It will be stated there during updates which bug fixes have been implemented at each update.


Our developers made a temporary fix, which you can apply right now, if you wish.
Find this PHP file via FTP ( or your hosting file manager), on your WP hosting server, in the WordPress folder :
..\wp-content\plugins\wpdatatables\source\class.wpdatachart.php
Around line 1297, find this function :

public function defineSeries()
{
    if (!empty($this->getUserDefinedSeriesData())) {
        $seriesIndex = 0;
        foreach ($this->_user_defined_series_data as $series_data) {
            if (!empty($series_data['color']) || !empty($series_data['type']) || !empty($series_data['label'])) {

                if (!empty($series_data['color'])) {
                    $this->_render_data['options']['series'][$seriesIndex] = array(
                        'color' => $series_data['color'],
                    );
                }
                if (!empty($series_data['label'])) {
                    $this->_render_data['options']['series'][$seriesIndex] = array(
                        'label' => $series_data['label']
                    );
                }
            }
            $seriesIndex++;
        }
    }
}

Replace it with this :

public function defineSeries()
{
    if (!empty($this->getUserDefinedSeriesData())) {
        $seriesIndex = 0;
        foreach ($this->_user_defined_series_data as $series_data) {
            if (!empty($series_data['color']) || !empty($series_data['type']) || !empty($series_data['label'])) {

                if (!empty($series_data['color'])) {
                    $this->_render_data['options']['series'][$seriesIndex]['color'] = $series_data['color'];
                }
                if (!empty($series_data['label'])) {
                    $this->_render_data['options']['series'][$seriesIndex]['label'] =  $series_data['label'];
                }
            }
            $seriesIndex++;
        }
    }
}

Save the change, and check, this should fix the issue. Now all the charts should be able to save your custom color per series.

If you need us to edit this code for you, we will need the following access :

Please provide me a temporary WP-admin (administrator) user for your website where this happens, 

as well as FTP credentials and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),

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.