 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / March 2005Logarithm scaling for charts
When using logarithmic scaling for charts the scaling interval is given in powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling interval to show data at a smaller log. interval (e.g. between 100 and 200). This is not at present possible in Excel but it would be extremely useful. > When using logarithmic scaling for charts the scaling interval is given in > powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling > interval to show data at a smaller log. interval (e.g. between 100 and 200). > This is not at present possible in Excel but it would be extremely useful. Greetings, There is an explanation regarding your query. Click on- http://groups-beta.google.com/group/microsoft.public.excel.charting/browse_frm/t hread/1ff81f9f2e110592/36c9fffc1d4abe6c?q=richardg#36c9fffc1d4abe6c Careful about the word wrap. Or search on richardg. Best regards, RichardG Tushar Mehta shows how to fake this on his web site: http://tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.html I've posted several examples of faking specialty axes with extra XY series on my site, if you need a couple examples to get started: http://peltiertech.com/Excel/Charts/axes.html Start with the Arbitrary Axis Scale example, and go from there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > When using logarithmic scaling for charts the scaling interval is given in > powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling > interval to show data at a smaller log. interval (e.g. between 100 and 200). > This is not at present possible in Excel but it would be extremely useful. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.