x log, y lin audio frequency chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 19 Dec 2007 15:53 GMT

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

Reply to this Message

Earl Kiosterud - 20 Dec 2007 05:46 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> 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
[quoted text clipped - 6 lines]
> Thanks and sorry about the many questions.
> JIM

Reply to this Message

Andy Pope - 20 Dec 2007 08:36 GMT

Hi,

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

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> I'm having some trouble with limitaions in the axis display. Is there a
> way
[quoted text clipped - 8 lines]
> Thanks and sorry about the many questions.
> JIM

Reply to this Message

Gklass - 27 Dec 2007 16:15 GMT

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

> Hi,
>
[quoted text clipped - 17 lines]
> > Thanks and sorry about the many questions.
> > JIM

Reply to this Message