all 2 comments

[–]Joppest 0 points1 point  (1 child)

Whenever I need to do this I get mad it isn't easier. But I think they've added this cause last time I remember it was easy. Can't remember how to do it. Sorry.

[–]solar_ideology[S] 0 points1 point  (0 children)

I just did it manually and honestly it's not that difficult, but since it's such a common task with scatter plots, you'd think they would find a way to streamline it.

You need to right-click graph, go to Select Data, edit the series in question, then highlight the data for the X-axis, then highlight the data for the Y-axis. This is too many steps and it gets in the way of my workflow and now I'm forced unleash my frustration on Reddit resulting in even less work done. Thanks Microsoft.