Logarithmic axis
Hi, I have an urgent question
I need to be able to change my chart axis when they are logarithmic. As standard you can only decide 1,10,100 etc... I need for an example to change them from 1 to 500!!! Hope that someone can help me with a name on an ADDINN som a solution in some way -- Peter Svendsen Danish Technological Institute Engineer |
Hi,
Check out Tushar's flexible log example. http://tushar-mehta.com/excel/newsgr...ale/index.html Cheers Andy Peter Svendsen wrote: Hi, I have an urgent question I need to be able to change my chart axis when they are logarithmic. As standard you can only decide 1,10,100 etc... I need for an example to change them from 1 to 500!!! Hope that someone can help me with a name on an ADDINN som a solution in some way -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Hey
I should be able to use it... This is only with the y axis logarithmic.... If we have both y and x axis logarithmic it is the same procedure right? Thanks for the quick answer "Andy Pope" skrev: Hi, Check out Tushar's flexible log example. http://tushar-mehta.com/excel/newsgr...ale/index.html Cheers Andy Peter Svendsen wrote: Hi, I have an urgent question I need to be able to change my chart axis when they are logarithmic. As standard you can only decide 1,10,100 etc... I need for an example to change them from 1 to 500!!! Hope that someone can help me with a name on an ADDINN som a solution in some way -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Yes, just make sure you use a xy scatter and not a line chart.
Peter Svendsen wrote: Hey I should be able to use it... This is only with the y axis logarithmic.... If we have both y and x axis logarithmic it is the same procedure right? Thanks for the quick answer "Andy Pope" skrev: Hi, Check out Tushar's flexible log example. http://tushar-mehta.com/excel/newsgr...ale/index.html Cheers Andy Peter Svendsen wrote: Hi, I have an urgent question I need to be able to change my chart axis when they are logarithmic. As standard you can only decide 1,10,100 etc... I need for an example to change them from 1 to 500!!! Hope that someone can help me with a name on an ADDINN som a solution in some way -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com