How do I specify x-axis data for a logarithmic line graph?

K

kculerie

I have a 2 sets of data that I want to graph in a logarithmic line graph
where the y-axis is logaritmic and the x-axis is arithmetic. I essentially
have coordinates (x,y) that I want to plot, but excel automatically graphs my
selected coordinates as two series' of range values, and they take the
corresponding spreadsheet row number as the x-axis values.
 
B

Bernard Liengme

You have made a Line chart when an XY chart was needed.
A very common mistake caused by the odd name "line chart"
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

Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Use text descriptors as Y axis units 1
How do I specify X,Y axis and Series values in a line graph? 5
Logarithmic Scale for the X-Axis 1
Excel 2007: X-axis labeling 1
Chart with differing x axis 1
X-Axis Appearing in Plot Area 2

Top