How do I create a scatterplot with the data I want it to have?

Creed

All I want to do is set one column as my Y axis, one column as my X axis, and one column as my Labels. How do I do that?

Please explain where I can just tell smartsheets where I want the data to go. why does it just throw the data where ever it wants to?

Creed

It should be

Aircraft Number: label

% Completion: X axis

% of time: Y axis

Smartsheets refuses to do this

Genevieve P.

Hi @Creed

There currently isn't a way to have a text label appear next to a scatter plot dot within the chart. Please feel free to add your vote to this related Idea post to show your support for this feature request: Scatter plot chart - labels & values on both Axis, plotting combined Value vs Effort score intersect

If you select just the % Completion and % Time columns, you can then identify one as the X and one as the Y, like so:

If you need the Aircraft associated / next to the number, I would recommend a Bar Chart instead:

Cheers,
Genevieve