Semi-Log Plots w/User scaled Y-Axis

[Mike]

I want to plot data on a 2-cycle semilog X-axis with a Y-
axis scale defined by me, the user. i.e., major Y-axis
divisions would be 1/2 inches apart when printed. The
output graph is to be used with an overlay to detect
trends, etc.

Can this be done without earning a Microsoft Certification
in the process?

 

[Jon Peltier]

Mike -

You want a two-cycle log scale on the X axis? Make sure it's an XY
Scatter chart, then double click the X axis, click on the Scale tab,
check the Logarithmic Scale box, and pick minimum and maximum values
which are related by a factor of 100.

To get the Y axis divisions appropriately spaced, you could use VBA,
measure the height of the chart, do a bunch of algebra, and all. But it
might just be easier to make a good guess, print out a sheet, measure it
with a ruler, and adjust the scale accordingly to make it fit.

- Jon