HELP! - I have no idea how to do it

%3CLINGO-SUB%20id%3D%22lingo-sub-1830628%22%20slang%3D%22en-US%22%3EHELP!%20-%20I%20have%20no%20idea%20how%20to%20do%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830628%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20(scatter%3F)%20chart%20that%20will%20do%20the%20following%20on%20the%20axes%20A%20and%20P%3A%3C%2FP%3E%3CP%3E-%20show%20several%20items%20as%20xA%2C%20xP%3C%2FP%3E%3CP%3E-%20show%20several%20items%20as%20xA%2C%20xP%20-%20yA%2C%20yP%3C%2FP%3E%3CP%3EA%20similar%20chart%20I%20found%20on%20the%20net%20is%20attached%2C%20but%20I%20have%20no%20idea%20how%20it%20was%20made.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1830628%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-1831338%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20-%20I%20have%20no%20idea%20how%20to%20do%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1831338%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F837051%22%20target%3D%22_blank%22%3E%40ifiglus%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3CP%3EPlease%20find%20an%20example%3C%2FP%3E%3CP%3Eyou%20can%20make%20it%20look%20prettier%20also...%3C%2FP%3E%3CP%3Ehope%20this%20is%20useful%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1833806%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20-%20I%20have%20no%20idea%20how%20to%20do%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1833806%22%20slang%3D%22en-US%22%3EThanks%2C%20but%20how%20did%20you%20connect%20the%20two%20Panasonic%20points%20and%20how%20did%20you%20assign%20different%20colors%20to%20different%20sections%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1833938%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20-%20I%20have%20no%20idea%20how%20to%20do%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1833938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F837051%22%20target%3D%22_blank%22%3E%40ifiglus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20noticed%20each%20type%20of%20camera%20is%20a%20separate%20scatter%20plot.%3C%2FP%3E%3CP%3Eyou%20can%20then%20decide%20if%20a%20scatter%20plot%20has%20lines%20or%20not%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20want%20I%20can%20upload%20another%20example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeck%20this%20tutorial%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fpulse%2Fscatter-plots-excel-data-labels-ramiz-assaf%2F%3FtrackingId%3Dq02KurJ2GX0BdddDs1UV%252BQ%253D%253D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fpulse%2Fscatter-plots-excel-data-labels-ramiz-assaf%2F%3FtrackingId%3Dq02KurJ2GX0BdddDs1UV%252BQ%253D%253D%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to create a (scatter?) chart that will do the following on the axes A and P:

- show several items as xA, xP

- show several items as xA, xP - yA, yP

A similar chart I found on the net is attached, but I have no idea how it was made.

4 Replies

@ifiglus .

Please find an example

you can make it look prettier also...

hope this is useful

Thanks, but how did you connect the two Panasonic points and how did you assign different colors to different sections?

@ifiglus 

 

If you noticed each type of camera is a separate scatter plot.

you can then decide if a scatter plot has lines or not

 

if you want I can upload another example

 

check this tutorial

https://www.linkedin.com/pulse/scatter-plots-excel-data-labels-ramiz-assaf/?trackingId=q02KurJ2GX0Bd...

 

@Ramiz_Assaf Wow! Thanks for the amazing tutorial! It will not only let me create a graphical representation of my camera lens collection, it will be a great crash course in how to create graphs in Excel. Terrific!