Hello danielpkennedy

Thank you for your purchase.

To be able to create tables from Excel files properly, you can't have empty cells like that. The first row in the Excel file needs to have column headers, and if there's a header missing - that column will not be added, or it will be joined with another one.

Please move the data up, add column headers for all columns, and try again.

Hi again Daniel.

Here's what I found. Your Excel file for the NAV table has float numbers, some have 2 decimals, some have 11. wpDataTables can't handle that, so I changed the number format to match your Excel file (15,000.00) and I changed the number of decimals in floats to 11 in main settings of wpDataTables:

Now the table looks like it does in Excel.

The thing with the chart is that the first column is taken as an X axis column, and that's why you're not able to achieve what you're trying to achieve.

You would need to change the original table, so it looks like this:

And here's how the chart would look like from the first 3 rows:

It's too close together, and has too little data, but it is what you were looking to achieve.

Ah, I see Daniel.

That is default behavior of charts engine, but if you need some custom solution you can check in 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 Support help center). 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 certain level of programming skills and included support refers only to advice.