Log Graphs

J

Julesy

How do i plot a log scale on the x axis, values of 0-1 on the Y axis,
but still be able to extend the graph down to say -10 so i can
extrapolate it?? Hope this query makes sense!! Tahnks to all who look
 
J

Jon Peltier

Julesy -

First, you need to make an XY Scatter chart. A Line chart won't allow a
log scale on the X axis. Double click on the X axis, click on the Scale
tab, and check the Logarithmic Scale box. Double click on the Y axis,
enter -10 for the minimum setting, 1 for the maximum, and if you want
that X axis at the bottom, enter some silly large negative number, like
-99999999, in the X Axis Crosses At box.

- Jon
 

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

Y axis log scale flipping 0
Graphs 1
extrapolating points on a trendline 1
if statement with vlookup 1
graphs 1
Problem with Graphs 1
updating graphs 3
semi log graphs 3

Top