Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |