Here at home I have Excel XP. I'd like to make a semi-log graph. This is a
graph with a log y-axis, and non-log on the x-axis. In this case I have
dates on the x. Semi-log is used to show rate of change. Going from 10 to
11 is a 10% increase. Likewise going from 100 to 110 is 10%. The semi-log
will show both of these with the same slope.

Going to my graph options I could only find a log, which seems to make both
axes log scales. I could in Excel convert to logs, but a semi-log is a
pretty standard graph and should be an option.

Don <donwiss at panix.com.

Just use a scatter plot from the chart wizard. Once it's created, you
can set either axis independently to be a log scale versus a linear
scale. Double click on the axis you want to change and choose the scale
tab of the dialog box.

Dave Ring

Don Wiss wrote:
Here at home I have Excel XP. I'd like to make a semi-log graph. This is a
graph with a log y-axis, and non-log on the x-axis. In this case I have
dates on the x. Semi-log is used to show rate of change. Going from 10 to
11 is a 10% increase. Likewise going from 100 to 110 is 10%. The semi-log
will show both of these with the same slope.

Going to my graph options I could only find a log, which seems to make both
axes log scales. I could in Excel convert to logs, but a semi-log is a
pretty standard graph and should be an option.

Don <donwiss at panix.com.

On Mon, 24 Nov 2003 18:26:22 -0800, Dave Ring wrote:

Don Wiss wrote:
Here at home I have Excel XP. I'd like to make a semi-log graph. This is a
graph with a log y-axis, and non-log on the x-axis. In this case I have
dates on the x. Semi-log is used to show rate of change. Going from 10 to
11 is a 10% increase. Likewise going from 100 to 110 is 10%. The semi-log
will show both of these with the same slope.

Going to my graph options I could only find a log, which seems to make both
axes log scales. I could in Excel convert to logs, but a semi-log is a
pretty standard graph and should be an option.

Just use a scatter plot from the chart wizard. Once it's created, you
can set either axis independently to be a log scale versus a linear
scale. Double click on the axis you want to change and choose the scale
tab of the dialog box.

Hey. That was easy! It already was a scatter/x-y chart. This is a chart of
my spams per day. It is growing so rapidly I need to compress the scale and
have a comparable growth rate. I'll be able to go a few more months now
before it hits the 1000 line.

Don <donwiss at panix.com.

I thought spam was bad, but I'm coming to resent junk faxes even more.
When Dante does a rewrite of the Inferno, he'll have to think of some
ingenious rewards for spammers. Does the karmic burden of trivial evil
scale linearly when multiplied by millions of victims? Is the
automation of evil in itself a new sin?

Dave

Don Wiss wrote:
On Mon, 24 Nov 2003 18:26:22 -0800, Dave Ring wrote:


Don Wiss wrote:

Here at home I have Excel XP. I'd like to make a semi-log graph. This is a
graph with a log y-axis, and non-log on the x-axis. In this case I have
dates on the x. Semi-log is used to show rate of change. Going from 10 to
11 is a 10% increase. Likewise going from 100 to 110 is 10%. The semi-log
will show both of these with the same slope.

Going to my graph options I could only find a log, which seems to make both
axes log scales. I could in Excel convert to logs, but a semi-log is a
pretty standard graph and should be an option.


Just use a scatter plot from the chart wizard. Once it's created, you
can set either axis independently to be a log scale versus a linear
scale. Double click on the axis you want to change and choose the scale
tab of the dialog box.


Hey. That was easy! It already was a scatter/x-y chart. This is a chart of
my spams per day. It is growing so rapidly I need to compress the scale and
have a comparable growth rate. I'll be able to go a few more months now
before it hits the 1000 line.

Don <donwiss at panix.com.