Hi Victor,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

You will not be able to achieve that with any of our available Charts/chart engines.

The way how the charts work is, you are now having just a single row of data in your table.

Each row is being represented as one Data point on the X axis for any Chart.

The only way to achieve the Chart and the multiple data points on the X axis as on the example, will be to have one Date(or String or integer) Column in which each row is going to be one month;

so for example, the Column which holds the Year and the month would have rows going the same as the data points on the X axis for each row;

such as : 

first row for the Date data would be 2019 Jan, then 1st row for the Series data says  76.05;

second row :

2019 Mar  >  the Series Column : 80,38;

and so on....

I am just curious how you were able to achieve this on a Chart with only one row to have multiple X axis data points like that;

you wrote : 'Every other separate chart program (non WPDataTables) I can successfully do it with the current data setup.'

Could you show us an example of a chart program, and how is your source data for the chart looking, and how are you setting up that chart with the chart options, etc?

In our Plugin with all our Charts, though, this is currently not possible in any way.

Let me know if you have any additional questions about that.

Thank you.

Hi Victor,

Thank you for sharing these details, this could help us as ideas for a future development option.

I will pass this to our devs, just as working examples, and they will do their best to create a new feature, we just can't say a realistic ETA on it.

If you wish to affect the development speed;

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 have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)

For the time being, this will not be possible for our Charts;

as we have shown, in any of our Charts, for the X axis, it needs all the values to be set in that one "Date or String" Column, while all the other Columns must be numerical, etc.

I can see you figured all of this out in the end, and I am sorry to see this difficult situation, where you have so much data that would need to be transposed in order to be used with our Charts;

At the moment, sadly, there is no easy way we could suggest to somehow 'transpose it' without manual work.