View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Logarithmic graphs in Excel

Double click the Y axis, and on the Scale tab, check the Logarithmic Scale
box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"BigDaddyCool" wrote in message
...
Hello! I have some Excel data that lists the United States' Gross Domestic
Product for each year from 1890 to 2000. The data looks like this:

1890 260.42
1891 271.87
1892 298.51

...

1998 8495.65
1999 8848.225
2000 9156.6

I wanted to turn this data into a groovy looking line graph, so I tried
using Excel's built-in Chart Wizard, but the resulting graph looks WAY too
much like an exponential curve (not to mention the fact that it really
doesn't all that good), so I want to turn it into a logarithmic graph. How
can I accomplish this?