There is no built-in option, 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. You can use it for adding options that are available in Chart.js API. In this callback in method wpDataChartsCallbacks 82 is the ID of the chart for which you want to change colors. We used hex color codes with some random colors, but you can change it for your needs. There are six of them (if you have six series), if you had it more then you have to add more colors in colors array, separated by a comma (except last one). On the end insert this script above shortcode of your chart on the page.

<script type="text/javascript">
jQuery(window).on('load',function(){
    if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; }
    wpDataChartsCallbacks[82] = function(obj){
        obj.options.data.datasets[0].backgroundColor = [
                                                        '#50B432',
                                                        '#ED561B',
                                                        '#DDDF00',
                                                        '#24CBE5',
                                                        '#64E572',
                                                        '#FF9655'
        ]
    }
});
</script>

There is no built-in option, 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. You can use it for adding options that are available in Google Api. In this callback in method wpDataChartsCallbacks 83 is the ID of the chart which you want to change colors. We used hex color codes with some random colors, but you can change it for your needs. There are six of them (if you have six series), if you had it more then you have to add more colors in colors array, separated by a comma (except last one). On the end insert this script above shortcode of your chart on the page.

<script type="text/javascript">
jQuery(window).on('load',function(){
    if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; }
    wpDataChartsCallbacks[83] = function(obj){
        obj.options.colors = [
                     '#50B432',
                     '#ED561B',
                     '#DDDF00',
                     '#24CBE5',
                     '#64E572',
                     '#FF9655'
        ],
     obj.options.pieSliceText = "percentage"
    }
});
</script>

Yes, you can. You just need to turn on the option “Parse shortcodes” in main Settings of the plugin.

Yes you can, but you have to make one more table. From first table where you turn on option User can see and edit own data you can use table name from option MySQL table name for editing which you can find on Editing tab in table settings.

Then make another table from MySQL query like this:

SELECT * FROM table_name_for_editing

Instead of table_name_for_editing you will use table name from option MySQL table name for editing. Like this will be shown all data from all users.

When you are moving on live site from local or stage site we can suggest to use Plugin Duplicator. We use it and it’s working fine, because he will transfer all the files and also the tables to database.