How to plot this graph in Excel?
EDIT: Complete rewrite.
Select the two columns of data, with the first column being the X axis. Then insert a scatter chart.
(And here I thought the line graph was the easy one.)
If you want to display the numbers as kilo-ohms, I suggest you divide the numbers in the column by 1000 and use the custom number format: 0" kΩ"
Even better, don't divide the original data. use a custom number format of 0," kΩ"
where the comma after the zero removes three zeros to show thousands. In the same way 0,," MΩ"
has two commas, so three sets of three zeros are removed, showing millions.