scatter plot custom x-axis labels
is it possible to use text labels for the x axis on a scatter plot? it seems to default to sequential count from zero.
If the "text" is numeric, then yes (or sometimes yes) the X axis can be text but you really should have it be a numeric format. Scatter plots are true X-Y charts. X and Y must be numeric.
But you may be asking "why is the X axis of my scatter plot always 0, 1, 2, etc.". Scatter charts want the X and Y in the regular cells. This is unlike all of the other charts that want the X axis data/labels in the header column and the Y data in regular cells. I say "want" because that is the default, but it can be overridden with some effort.
In the screenshot below, I selected columns B and C to create the scatter chart.