I would like the x axis to be years but however I change the source and the order of the columns used in the chart the years appears on the y axis. I am using a plotter chart; and I have tried both google and high charts.
Also the date field don't allow me to just use year it has to be at least a month as well.
The string-type columns (string, date, datetime, URL, etc) will always be used for the X-axis while numerical columns (integer and float) will be plotted on the y-axis.
You would need to restructure the chart in order to have it show what you need, and even in that case, we can't guarantee that you'd be able to achieve the desired chart since chart engine's logic can't be changed from within wpDataTables.
Can you please show me the table, and a mockup of a chart you want to see? I'll do my best to create a table you could use.
Thank you, that makes sense now. I think I solved the x/y axis issue. However I have a list of years with prices that I want to put on a plotter chart and it seems to put the same year over and over again.
Sorry for the late response, we've had some non-working days in our country.
Unfortunately, I can't open the spreadsheet because I don't have access to the original sheet:
Based on the screenshot, I can only say that if the years repeat in the table (if there are multiple values linked to the same year), it will also repeat in the chart.
How do I switch the x & y axis in a chart?
I would like the x axis to be years but however I change the source and the order of the columns used in the chart the years appears on the y axis. I am using a plotter chart; and I have tried both google and high charts.
Also the date field don't allow me to just use year it has to be at least a month as well.
Thanks!
Hello Mee
The string-type columns (string, date, datetime, URL, etc) will always be used for the X-axis while numerical columns (integer and float) will be plotted on the y-axis.
You would need to restructure the chart in order to have it show what you need, and even in that case, we can't guarantee that you'd be able to achieve the desired chart since chart engine's logic can't be changed from within wpDataTables.
Can you please show me the table, and a mockup of a chart you want to see? I'll do my best to create a table you could use.
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
Thank you, that makes sense now. I think I solved the x/y axis issue. However I have a list of years with prices that I want to put on a plotter chart and it seems to put the same year over and over again.
Source...
https://docs.google.com/spreadsheets/d/1Eo4RsN0athQBhE33cNA0TTQ8VZzqpSZRM3e1JqJSa6w/edit?usp=sharing
This is how it comes out for me...
https://imgur.com/a/1KBBmvT
Also, is there any way of doing a second y axis line chart?
Thanks!
Hi again Mee
Sorry for the late response, we've had some non-working days in our country.
Unfortunately, I can't open the spreadsheet because I don't have access to the original sheet:
Based on the screenshot, I can only say that if the years repeat in the table (if there are multiple values linked to the same year), it will also repeat in the chart.
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