Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set log chart minimums and maximum?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting maximums or minimums | Excel Discussion (Misc queries) |