Forum Discussion
Help with 3D scatter plot
I am trying to create a 2D scatter plot. Attached is a snapshot of my data. Here is how I would like this to look:
1. Data speed on the vertical dimension.
2. Timeline on the horizontal dimension.
3. Each point has the description for that point in the plot area next to the data point.
4. Different color of data point depending on wireless or wired information.
Can Excel do this?
Up to date version of Excel on Windows 11.
You may add two helper columns for wired and wireless to use different colors for them. For the labels select an option to take them from cells.
7 Replies
You may add two helper columns for wired and wireless to use different colors for them. For the labels select an option to take them from cells.
Thanks Sergei. That got me unstuck, but hit one more issue I can't figure out. The years are showing up as a data series and I want them to be the horizontal axis labels. Cn you help?
Perhaps I misunderstood, but years are X-axis in the sample, you may click on each of series to check. Or you mean something else?
