making a scatter plot with selected data

Your description of what is on the x axis and y axis are the other way around from the list of ordered pairs. It would help if you attach your actual file and the image of what you want.

these numbers above should not be the actual number aka 100000, it should be listed as 10^4 in the axis.

The way you are writing the numbers for the x axis is not a supported format in Excel; in fact, it is not a standard format that I have ever seen (using decimal numbers as exponents of 10). It's valid arithmetic but I've never seen it used for anything. Anyway, the way you are writing it is a text string in Excel, and it just won't work. For a scatter plot using real numbers, you have to use actual real numbers (i.e., instead of 10^5.7 you'll have to use 501,187.23 or 5.01E+05). You could manage this if your x values were discrete and you could list every possible value; then you use text. But since they are real numbers, that won't work.

Other than the 10 [superscript] exponent notation, this should be straightforward. Enter/calculate the x values in one column and enter/calculate the y values in an adjacent column. Select the two columns and insert your scatter chart, then format as desired.

If all you have are the exponents, I would:

1) Enter the exponents into a column.
2) Calculate the x values in the adjacent column with =10^A1 or =POWER(10,A1). Assume column B for this.
3) Enter y values in column C.
4) Insert and format chart.

If you are not required to use the 10^x notation, it should be as easy as that.

This is as close as you can come (note that you need a logarithmic scale on the x axis). BTW your data does not make a curve anything like that.

EDIT: I more or less did what MrShorty described.

chart.jpg

File attached. I had to sort your data by ascending x value.

You have to format the x axis to be logarithmic scale

log scale.jpg

thanks for the reply. I had work so i could not reply back till now. i tried this and it just squezes the data, does not make it look much different. Needs to look like the graph on the right.

thank you

log graph.JPG

If your data is not like the data on the left, your graph won't look like the graph on the left. The chart correctly represents the data you have.

Why are you expecting it to look different than that.

It is difficult to debug pictures. Is the picture in post #7 accurate? I don't see any of the expected x values anywhere in that picture. If you only give a scatter chart the y values with no x values, Excel will assume count numbers (1,2,3,...) for the x values, which seems consistent with what you show in the picture.

I'm grasping at straws here, but it appears to me that you forgot to include the x values when you created the chart in your picture in post #7.

And I can see those y values in the spreadsheet in your picture, but I am not seeing any of the x values (or log(x) or 10^(log(x)) values. Where have you entered the desired x values? Did you instruct the chart where to find those x values?

on the far left of the excel sheet are my x values written out as the actual number (post 7 shows them). If i right click on the chart, select data, i can edit the series and choose the x values to be the 10,100,1000,10000,1000000 etc etc and the y values as the others listed above. I tried to use the other set of numbers as the Y axis as well, but it made things worse haha

That would mean you have only 5 x values, but 15 y values, with no way for Excel to know what x values should pair with each y value.

Review 6stringjazzer's file and see how he arranged the x, y pairs in the spreadsheet and then how he defined the data series in the chart.