Hi danelige,
Thank you for the purchase. Sorry for delayed reply.

1. you are setting display: none for some weird reason... annoying.

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 because just check PRIVATE so nobody can see it except us.

2. documentation: HOW do you set the axes of the chart? for example if I need the date to be on the x-axis? not clear. 

String, Date and Datetime columns that is added in chart are used for categories, and numeric columns that are added in the chart are used for categories. Some chart types by default set Categories values on the X-Axis (Line chart, Column chart...) and some chart types on Y-Axis (Bar chart,  Stacked bar chart). What chart engine are you using and what chart type?

Also there is an option in Axes tab Invert and if you check this option you'll invert the axes so that the x axis is vertical and y axis is horizontal.

3. is multiple axis charts possible? (like the attached)

Not out of the box but it can be done using wpDataChart callback. You can take a look at usage and examples of wpDataChart callback at this link from our documentation - Link.

Also I have one example of different chart series and multiple axes so you can take a look at this example at make it by your own needs. This example is for Highcharts chart library:

<script type="text/javascript">
jQuery(window).load(function(){
if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; }
wpDataChartsCallbacks[46] = function(obj){
  obj.options.yAxis = [],
  obj.options.yAxis[0] = {},
  obj.options.yAxis[0].title = {},
  obj.options.yAxis[0].title.text = 'Test 1',
  obj.options.yAxis[1] = {},
  obj.options.yAxis[1].title = {},
  obj.options.yAxis[1].title.text = 'Test 2',
  obj.options.yAxis[1].opposite = true,   
  obj.options.series[0].type = 'column',
  obj.options.series[1].type = 'spline',
  obj.options.series[1].yAxis = 1
}
});
</script>

Hi danelige,

With these credentials that you have sent me I don't have administrator privileges. Can you promote me to admin?

I didn't quite understand your second question? Are you asking if you create a chart from Google Spreadsheet and update that file later, will chart data also update? If that is not the case can you describe me your question in more details.

Hi danelige,

I saw that there is no issue with Chart Wizard. I then take a look at the image from your first ticket and see that you have added 2 columns. One column was date and one was string. I had a red notice that says: Please do not add more then one string-type (date/time, image, email, URL) column since only one can be used as a label. So when you are creating charts you can add just one column that will be string/date/datetime column type and other columns should be numeric.

second question: I wanted to know whether I can set for the plugin to import google sheets data ONCE, and not auto-update going forward. 

- You can take a look at this post from our documentation how to create wpDataTables from Google Spreadsheet - Link. After you update Google Spreadsheet wpDataTable will be updated automatically after 10 minutes because of the cache on Google side.

Hi danelige,

So you are saying that I cannot set cache to infinite and switch OFF auto-update?

- Can you explain me your question in more details?

Milos, come on man, where is that NEXT button!?

- Please read my last reply where I described you in details why you don't see Next button. You can't add two columns where one of them is String column type and other is Date column type.

Hi danelige,

2. the google sheet link pulls data from my google sheets into wpTable and then into the chart right? Then when I update the google sheet, the wpTable automatically updates with the new values right? I dont want that to happen. I want to pull that google sheets data into the wpTable ONLY ONCE.  and after that I do not want the wpTable values to update any more. 

- Yes that is right, if you update Google Spreadsheet file wpDataTable and wpDataChart will be updated automatically. If you don't want this to happens, the only solution is to create manual table from your Google Spreadsheet file using wpDataTables constructor. You can take a look at this link from our documentation how you can create table like that - Link

Hi danelige,

Sorry for the inconvenience. Problem with the table is related with Google Chart that is also on this page. It has some JS error that breaks the table also. I tried to find this page under the Pages list but as I see this page is protected  - http://www.rigasdynasty.com/markets/2017/test-wpdt/ Can you allow me to edit this page so I can see where is the issue? 

Hi danelige,

You can edit CSS by adding custom CSS code directly on the page between <style></style> tags or adding it in Custom CSS field on wpDataTables settings page. For example if you want to change header CSS you have to add something like this:

.wdtheader {
    //Your CSS properties
}

Hi danelige,

Did you Publish to the web this Google Spreadsheet file? Please take a look at the documentation how to create wpDataTables from Google Spreadsheet at this link. You'll see that you have to Publish it before you can use it in wpDataTables. 

Hi danelige,

In file../wp-content/plugins/wpdatatables/source/class.wpdatatable.php you can find

'orientation' => 'portrait',

and replace it with

'orientation' => 'landscape',

Hi danelige,

I am glad  that you have resolved the issue. I also tried to create wpDataTable from this Google Spreadsheet and now it's working.

Hi danelige,

Probably Google Spreadsheet document is not available on Google side and because of that wpDataTables is throwing an error. It can't create wpDataTable from Google Spreadsheet that is not available. Can you try to copy the link of Google Spreadsheet that you got in Publish to the web modal? Take a look at this video to see what am I thinking on - Link. Also can you send me that Google Spreadsheet and privileges to edit it? 

Hi danelige,

It is working fine on my side. wpDataTable is created from this Google Spreadsheet. Should I login to your website to check this issue or it is working for you also?