I have a requirement where I'd like to create a chart similar to the attachment.
The dataset is of the format:
However, whenever I upload the dataset, the scatter plot assumes that the first column is the x-axis, while what I'd like to plot is Trade against GDP, with the Country as a label.
Looking at your example of cloud bubble charts, which is somewhat similar to what I want to achieve, I can see that you have labels (or tooltips) like "US" and "FR" in your demo, but as soon as I try to download the underlying data, or even edit the chart, those labels are gone. How did they get there in the first place?
The question is therefore, which options do I have with respect to data formats?
I am in the process of creating themes, to ensure that the process of creating scatter plots in the future is as simple as possible for someone less technical than me. CSV would be preferable, but I need to know whether that is an option.
If not, what do I do?