SOLVED

Help with 3D scatter plot

%3CLINGO-SUB%20id%3D%22lingo-sub-2727501%22%20slang%3D%22en-US%22%3EHelp%20with%203D%20scatter%20plot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727501%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%202D%20scatter%20plot.%20Attached%20is%20a%20snapshot%20of%20my%20data.%20Here%20is%20how%20I%20would%20like%20this%20to%20look%3A%3C%2FP%3E%3CP%3E1.%20Data%20speed%20on%20the%20vertical%20dimension.%3C%2FP%3E%3CP%3E2.%20Timeline%20on%20the%20horizontal%20dimension.%3C%2FP%3E%3CP%3E3.%20Each%20point%20has%20the%20description%20for%20that%20point%20in%20the%20plot%20area%20next%20to%20the%20data%20point.%3C%2FP%3E%3CP%3E4.%20Different%20color%20of%20data%20point%20depending%20on%20wireless%20or%20wired%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20Excel%20do%20this%3F%3C%2FP%3E%3CP%3EUp%20to%20date%20version%20of%20Excel%20on%20Windows%2011.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Data%20Speeds.PNG%22%20style%3D%22width%3A%20861px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308465iEDFC39530EE4CCB2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Data%20Speeds.PNG%22%20alt%3D%22Data%20Speeds.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2727501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2728541%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%203D%20scatter%20plot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728541%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1148586%22%20target%3D%22_blank%22%3E%40jeffki123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20two%20helper%20columns%20for%20wired%20and%20wireless%20to%20use%20different%20colors%20for%20them.%20For%20the%20labels%20select%20an%20option%20to%20take%20them%20from%20cells.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308540iA8577DD890F7CF1A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2729860%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%203D%20scatter%20plot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2729860%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Sergei.%20That%20got%20me%20unstuck%2C%20but%20hit%20one%20more%20issue%20I%20can't%20figure%20out.%20The%20years%20are%20showing%20up%20as%20a%20data%20series%20and%20I%20want%20them%20to%20be%20the%20horizontal%20axis%20labels.%20Cn%20you%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Data%20Transfer%20Table.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308618i8F1630ECBA225ABE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Data%20Transfer%20Table.PNG%22%20alt%3D%22Data%20Transfer%20Table.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Data%20Transfer%20Chart.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308617i019820AE27B37048%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Data%20Transfer%20Chart.PNG%22%20alt%3D%22Data%20Transfer%20Chart.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.Data Speeds.PNG

7 Replies
best response confirmed by jeffki123 (Occasional Contributor)
Solution

@jeffki123 

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.

image.png

@Sergei Baklan 

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?

 

Data Transfer Table.PNGData Transfer Chart.PNG

@jeffki123 

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?

image.png

@Sergei Baklan 

Thank you. This is so close to what I want. Can you think of a way to keep the Morse Code point near 1840 and at the same time eliminate the white space between 1860 and 1960 so all the points on the right can spread out across the chart?

Data Transfer Chart.PNG

@Sergei Baklan I found that the recommended solution to my space problem was to create two charts. One with all the data and one without the 1844 outlier. As you can see, in the first chart below, the data labels are all off by one cell. I can't see how to fix this.

Select Data Source.PNGSheet 3.PNGSheet 2.PNGSheet 1.PNG

I got it! Thanks for your help Sergei.

@jeffki123 , great to know it works now