Hello, Weol Immo

I have been advised by our Senior Team, they checked all the details.

-

Basically, the main issue is that you are trying to get the same functionality from Excel to our WordPress plugin.

Unfortunately, it is not possible to achieve that,  because Excel has been around for a very long time and Microsoft developed certain functionalities,

some of the features from Excel are simply not possible with WordPress plugins and tables.

Because of that, we are not able to provide the same functionality as you need it, in terms of being able to filter and reverse the rows and headers in the same way as you can with Excel.

-

What i explained and elaborated on through this ticket is how our plugin table logic and the logic behind our available Charts work with the current capabilities.

-

Each chart can have only one String or Date column,  and the rest have to be numerical columns.

The first column selected will provide the horizontal X-axis labels,  while the other columns will provide the values for the Series.

-

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.

-

If you need the chart to follow table filtering,

you can place the chart on the same page with the source table, and activate "Follow Table Filtering".

- If you need to hide the table but only leave the table filters for the chart, refer to one of my previous responses where the solution is shared with CSS.

-

If you can not achieve what is needed with our built-in features,

 you can suggest a future improvement idea for our developers - they will do their best to make a solution in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

If you need a solution that is not possible with our built-in features, maybe it can be done with a high level of custom work, but I am not sure, to be honest. 

Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.

We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.