Semi-log graph?
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. |
Semi-log graph?
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. |
Semi-log graph?
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. |
Semi-log graph?
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. |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com