plotting 'random' data on a linear x-axis

G

Guest

I have a table (as shown below) and I'd like to do a simple line plot. I'd
like to be able to plot this with linear x and y axes with the data points as
shown in the table. Excel wants to evenly space the rows in my table along
the x-axis. How can I get it to use the value in column A for the position
of the data point on the x-axis?

x-axis y-axis
128 1572.58
192 1178.92
256 785.25
360 465.15
480 324.03
512 303.30
600 257.99
750 211.37
960 146.10
1600 99.27
1920 75.86
2880 54.82
3840 43.98
 
B

Bernard Liengme

You need an XY not a Line chart. ( a very common error - Microsoft should
change the name!)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting Date and Time on the same chart axis 1
Plotting data points on 2 axis 4
2nd axis plotting incorrectly - is there a chart size limit? 2
Secondary X-axis with reverse Y-axis 6
Plot a time series on the x-axis and categories on the y-axis 3
Consolidate my data and plot on a dual axis chart 3
Plotting x-y data to same physical dimension on plot 1
How do I specify x-axis data for a logarithmic line graph? 1

Top