3
I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this one.
In 1/3 octave band chart the next values must be equaly spaced in the 'x' axis: 63, 125, 250, 500, 1000, 2000, 4000 (Hz). You can see here an example of a chart:
Can I do it with VBA Excel? or there is an easier way to do it?