CANNOT get a scatterplot no matter how I try

%3CLINGO-SUB%20id%3D%22lingo-sub-2129341%22%20slang%3D%22en-US%22%3ECANNOT%20get%20a%20scatterplot%20no%20matter%20how%20I%20try%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2129341%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20used%20Excel%20for%20decades%20and%20am%20used%20to%20setting%20up%20a%20scatterplot%20by%20selecting%20two%20columns%2C%20and%20inserting%20a%20graph.%20Now%20I%20can't%20do%20it.%20Excel%20wants%20to%20force%20me%20into%20a%20line%20graph%20and%20then%20gets%20confused%20when%20I%20try%20to%20set%20the%20data%20values%20to%20reflect%20x%20and%20y%20coordinates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20help%20is%20of%20no-use%20because%2090%20%25%20is%20about%20format%2C%20DON'T%20CARE.%20I%20want%20my%20graph!!%20Is%20it%20possible%20that%20the%20people%20who%20revised%20Excel%20don't%20know%20what%20a%20scatter%20plot%20looks%20like%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2129341%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have used Excel for decades and am used to setting up a scatterplot by selecting two columns, and inserting a graph. Now I can't do it. Excel wants to force me into a line graph and then gets confused when I try to set the data values to reflect x and y coordinates.

 

The help is of no-use because 90 % is about format, DON'T CARE. I want my graph!! Is it possible that the people who revised Excel don't know what a scatter plot looks like?

1 Reply

@BillyGates2 What version of Excel and OS and stuff might help but you should be able to find scatter plot under Insert -> Charts -> and select the scatter plot option:

mtarler_0-1613174166832.png