x log, y lin audio frequency chart

[Jim]

I'm having some trouble with limitaions in the axis display. Is there a way
to set the base number of the log graph to start at 2, or 20, and stop at
20,000 or 40,000? It always defaults to decades of one or ten.
The second issue is when I set the series by using the wizard, the data is
off(lower) by an order of magnitude for some reason that is not very obvious
to me.
Finally, what is the difference between a range and a series? I have too
many points to use the range input.
Thanks and sorry about the many questions.
JIM

 

[Earl Kiosterud]

Jim

I don't think it's gonna happen. When you use an x-y (scatter) chart type, and set the x
axis to logarithmic, it uses multiples of 10 for the minimum and maximum values. If you're
using ISO 1/3-octave frequency values, you could actually put all 30 in your sheet (25, 31,
etc.) as categories in a regular line chart. That would give you a logarithmic set. I
don't think that's what you want, though. I think you're using an x-y (scatter) chart, with
the x axis set to Log and plotting points randomly as amplitude, frequency.

In your second issue, I don't know what you mean by "set the series by using the wizard."

For your third, a range is a group of cells on a sheet. A series is a set of values in a
chart. Most charts can have more than one series.

 

[Andy Pope]

Hi,

Have a read of Tushar Mehta's flexible log pages.
http://tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html

Cheers
Andy

 

[Gklass]

This is one of the few things that 2007 does very well