Custom X-axis

[Fred]

Hi everyone.

I need to create a custom x-axis in which the values
double at each interval.

i.e. At the first interval the value must be 20, the next
25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do
not have an similar differences (e.g. 25-20 is not equal
to 62-5) I will still need these values to be equally
spaced.

Thanks for any help you give, it's greatly appreciated!

Fred.

PS. If you want to know what I'm doing, I'm plotting an
amplitude:frequency graph, where each spacing between each
frequency is 1/3 of an octave.

 

[Jon Peltier]

Fred -

Two options. Make a Line chart, or make yourself a custom axis
according to these instructions (align it on the horizontal axis, not
the vertical):

http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryAxis.html

or this:

http://www.geocities.com/jonpeltier/Excel/Zips/Livestock.zip

- Jon

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Fred.
Please use the newsgroup for further discussion.]

Well, you can always simulate the effect.

Create a series that has equidistant values for the x-values
(1,2,3,4,etc.) and zero for all the y-values. Plot this series.

In another column, for each point in this dummy series, enter the label
you want (20. 25, 31.5, etc.) Use Rob Bovey's XY Chartlabeler (free
from www.appspro.com) to add this column as labels to the dummy series.

Remove the default x-axis formatting (double-click the axis, then in
the resulting dialog box, in the Patterns tab, set the Tick Mark Labels
to None). Adjust other formatting as desired.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[dvt]

Hi everyone.

I need to create a custom x-axis in which the values
double at each interval.

i.e. At the first interval the value must be 20, the next
25, 31.5, 40, 50, 62 ...20,000. Even though the numbers do
not have an similar differences (e.g. 25-20 is not equal
to 62-5) I will still need these values to be equally
spaced.

Thanks for any help you give, it's greatly appreciated!

Fred.

PS. If you want to know what I'm doing, I'm plotting an
amplitude:frequency graph, where each spacing between each
frequency is 1/3 of an octave.

1/3 octave data should probably be plotted on a log scale. I'd start with a
logarithmic x-axis.

Now if you need labels at 1/3 octave center frequency, you will probably
need to use a dummy series with labels. Jon and Tushar gave you the details
on that one a few days ago, so I won't replicate their efforts.

Dave
dvt at psu dot edu