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 How do I set log chart minimums and maximum?

Excel does not support log scales that do not terminate at powers of ten,
but you can fake it by transforming your data and building a fake axis.
Tushar Mehta shows how on his web site. Browse to http://tushar-mehta.com
and look for the Flexible Log Axis.

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


"Erik M." <Erik wrote in message
...
I'm plotting logarithmic data that stays in a relatively narrow range, so
I
need to set minimums and maximums on my y axis that are near each other
(e.g.
10 and 20). How do I do this in Excel? Is there a chart add-in that will
make this work for me?

I've been searching for an answer for years now, so any assistance would
be
greatly appreciated! :)

Thanks,
Erik