Using text string in x-axis in XY scatter plot

[mahmoodn]

I have a data point set like this

Please Login or Register  to view this content.

I have selected the XY scatter type. Problem is that the X-axis contains 1, 2, 3. However I want to see x1, x2, x3.
How can I change the default format?

[XOR LX]

Hi,

Not sure I understand. An x-y scatter plot is designed to do precisely just that, i.e. plot one set of values (x-axis) against another (y-axis).

Regards

[Andy Pope]

If your x values are really text use a line chart which will display the xaxis as category

Your data suggests you want to plot 2 series (base and second)

[mahmoodn]

Yes thank you. I used the line chart and then set the line color to "No color". Then the lines were gone and the point remained.