Hello Christian.

Thank you for your purchase.

Can you, please, tell me if the column is a Date type column, or a string? Also, how was the table created?

Did you enable "Follow table filtering" when you created the chart?

A good point to note is that you have to set the date format to be the same in the source file (if you created the table from an external file), wpDataTables and WordPress settings.

If you created the file from an external source, and if you don't have any sensitive data there, can you send it to me so I can test it locally? It should be sorting by date (by default) if you used the "date" type column.

Best regards.

Hello Christian.

When you're creating the chart, the displayed preview is pulling the data from the database, in the order you entered those values. So, that's why previews always displayed "wrong" - it displayed the results before you sorted the table by Date column.

The second thing is that you added chart #3 which is created from table #18, but instead of table #18 you added table #7 when you created the page. That's why "Follow table filtering" didn't apply here:

Also, the general settings of WordPress didn't have the same date format:

I changed that to d/m/Y as well.

I replaced the tables - from #7 to #18, and when you take a look at your page now it sorts normally.

https://fiengineer.com/investments/

Best regards.

You're welcome Christian.

Glad I could help.

If you want the charts to follow table filtering, then both the page and the chart need to be displayed on the same page. Also, if you want the filters to be shown, the table must be present as well.

Now, there is a way to simply hide the table using CSS, leaving only the chart and the filters. Anyone who knows CSS will be able to still display the table if they were to inspect the page, and simply change the properties.

You would first need to disable the following in table settings:

"Show X entries" drop-down; "Info Block" from Display tab:

"Enable main search block" from Sorting and Filtering tab:

And "Table Tools" from Table Tools tab:

Then, you can hide the table, leaving the filters above the chart like this:

<style>
.wpdt-c .wpDataTablesWrapper table {
display: none !important;
}
</style>
[wpdatatable id=1]
[wpdatachart id=1]

And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.

I hope this helps.

Best regards.

Thank you, Christian

I'm glad I could help.

Best regards.