I have a 2 col csv file that wpdatatables is referencing in order to create a milticolored bar chart. From the attached pics you will see that one col in the table contains the names and the other col contains the values. I would like to have the various bars in multiple colors but the chart is only identifying volume as a series.
I understand that if I invert the csv file so that I only have 2 rows and 8 columns wpdatatables will allow the multicolor. Unfortunately, the data is dynamic and comes daily in this format. Do you have any suggestions?
This is the way the chart engines work. Like you said - you would need to pivot the table, so you have 2 rows and 8 columns, but I can understand how difficult that can be for live data.
I have a 2 col csv file that wpdatatables is referencing in order to create a milticolored bar chart. From the attached pics you will see that one col in the table contains the names and the other col contains the values. I would like to have the various bars in multiple colors but the chart is only identifying volume as a series.
I understand that if I invert the csv file so that I only have 2 rows and 8 columns wpdatatables will allow the multicolor. Unfortunately, the data is dynamic and comes daily in this format. Do you have any suggestions?
Hello Terry
This is the way the chart engines work. Like you said - you would need to pivot the table, so you have 2 rows and 8 columns, but I can understand how difficult that can be for live data.
At the moment, there are no workarounds for this.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables