Hi there, I'm trying to use a scatter chart with a categorical x-axis (i.e. it's more of a dot-plot than a scatter chart). I have sorted the values in my x-axis by an "order" column like below: ...
Hi All,
I think I've found a way around this issue. If you switch the scatter graph to a line graph (keeping axis, details and legend data fields the same), you can remove the lines and add in the data points without the x-axis distorting.
In the line graph, navigate to Format > Shapes and change the stroke width to 0 and enable 'Show Marker' or 'Customise Series' to show and customise the data points.
The only issue with this is I don't think you can change the size of the data points to show another column/ measure like in the original post.
Thanks