Excel Scatter Plot Data Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-3024926%22%20slang%3D%22en-US%22%3EExcel%20Scatter%20Plot%20Data%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3024926%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20am%20having%20problems%20with%20making%20a%20scatter%20plot.%20I%20have%20my%20X%20and%20Y%20data%20values%20in%20columns%20next%20to%20each%20other%2C%20but%20when%20I%20select%20that%20data%20and%20click%20scatter%20plot%2C%20it%20just%20shows%20a%20single%20point%20on%20the%20graph.%20Any%20idea%20how%20to%20go%20about%20fixing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3024926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3024982%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Scatter%20Plot%20Data%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3024982%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1235650%22%20target%3D%22_blank%22%3E%40arogalla%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBoth%20the%20x-values%20and%20the%20y-values%20of%20a%20scatter%20plot%20%3CSTRONG%3Emust%3C%2FSTRONG%3E%20be%20numbers.%3C%2FP%3E%0A%3CP%3EThe%20values%20in%20B2%3AB6%20are%20text%20values%2C%20however.%20Perhaps%20you%20meant%20to%20use%20formulas%20such%20as%20%3D1%2F294.8%20etc.%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone,

I am having problems with making a scatter plot. I have my X and Y data values in columns next to each other, but when I select that data and click scatter plot, it just shows a single point on the graph. Any idea how to go about fixing this?

 

1 Reply

@arogalla 

Both the x-values and the y-values of a scatter plot must be numbers.

The values in B2:B6 are text values, however. Perhaps you meant to use formulas such as =1/294.8 etc.?