Well, that's what I mean. The correct formula, as in the Excel spreadsheet I provided, will give the correct data, as in the image I uploaded. Because your Time(Days) column contains the wrong values, you must have the wrong formula...
If you just enter your data into the spreadsheet I provided, without changing any formats or formulas, it will work :)
Hi clunkfish,
I think I'm missing something from your teachings.
Please, check the formulas and formats on my attached zip file.
Regards,
Flores
Problem identified :)
Your Time(Days) column is formatted as time, when it needs to be formatted as number. If you highlight the cells, right-click, go to "Format Cells...", then choose "Number" from the list of categories, the values under Time(Days) will change to the correct ones.
You also need to change the chart type, so that the values on the horizontal axis are arranged correctly. Just right-click the chart, choose "Change Chart Type...", and select "X Y Scatter". I think I had that wrongly set up in the original spreadsheet
Hope this helps you to make the chart you need.
Quote