Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi,
Just wondering if it is possible to select series that are visible on the X and Y axes in a scatter plot
I have just imported an excelsheet with 1 column with string values, and two columns with integer values. I would like to create a scatter plot, with both the integer values on the X and Y axes. The string value should be displayed the moment a viewer hovers over a dot.
When I try to create the scatter plot, I have no option what is displayed on each axes. So in my examples, the string values are displayed on the X axes and 1 of the integer series are displayed on the Y axes. So this scatter plot doesn't make any sense.
Hopefully someone can give me a hint what I'm missing out, or what I'm doing wrong?
Kind regards,
Marck
Hi Marck
Thank you for reaching out to us.
If you are using a String column, it will always be used for the X axis. So if you want to use only integer columns, the string cannot be displayed on hover. But, lest we guess, can you please send us that excel file and draw in Paint or wherever what you would like the chart to look, so we can try and recreate the scenario
Hi Blazenka,
Thanks for reaching out. I tried to attach an excelsheet, but I'm not allowed to attach an excelsheet.
Can I maybe send you a mail with the excelsheet?
Kind regards,
Marck
Hi Marck
Yes, of course. You can use my email address from the signature or simply attach a zip file to this response it will allow you to upload that way
Hi Marck
Thank you, we will try to recreate the chart on our end and forward you the best solution we come up with
Your time and patience is truly appreciated.
Fantastic. Really looking forward for what's to come. Thanks
Hello Marck.
Sorry for the late response.
Using the table you sent us we have no issues recreating the chart using only the two integer columns:
However, the string column cannot be plotted on the dots - if you add it, it will be on the X-axis, and each row would be considered as a new value on the X-axis, so you'd have"Abbott Rapid Diagnostics Jena GmbH" with coordinates 1, 64, "ACON Biotech (Hangzhou) Co., Ltd" with 1, 34, and so on.
That is the default behavior of the charts engine, and I don't know if some custom solution would help you out here. That custom solution would have to be applied through wpDataCharts callbacks.
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