Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto minimum on Y Axis
Hi all - If someone can help me here I would be most grateful. I have a chart which plots values over a time period of say 15 years. The value is entered in one cell and then a macro is run to generate the returns for each of the 15 years which the chart then plots. The problem is when the fund value is high say 1,000,000 originally and the returns are low, then it doesnt change much, but the Y axis starts at 0 so there is a massive gap and then you can't see much differential in the line graph. I have tried changing the chart options, but as the returns are variable I can't put it in a minimum. Any ideas?? Thanks -- mattjenkins ------------------------------------------------------------------------ mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558396 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto minimum on Y Axis
mattjenkins wrote on Wed, 5 Jul 2006 07:29:12 -0500:
m The problem is when the fund value is high say 1,000,000 m originally andthe returns are low, then it doesnt change m much, but the Y axis startsat 0 so there is a massive gap m and then you can't see much differentialin the line graph. m I have tried changing the chart options, but as the returns m arevariable I can't put it in a minimum. m Any ideas?? I suspect you must have considered it but the large range sounds just what a log axis is meant for. Do you have any negative values that might cause trouble with logs? James Silverton. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto minimum on Y Axis
some of the return %'s are negative values, but the line will never go into a negative value on the Y Axis - is this what you mean? I'm not sure what a log axis is Thanks very much -- mattjenkins ------------------------------------------------------------------------ mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558396 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto minimum on Y Axis
mattjenkins wrote on Wed, 5 Jul 2006 09:28:53 -0500:
m some of the return %'s are negative values, but the line m will never go into a negative value on the Y Axis - is this m what you mean? I'm not sure what a log axis is m Thanks very much-- m mattjenkins------------------------------------------------- m mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558396 Basically, it is an alternative to a linear scale on the y-axis. Click the chart/Right click y scale/Format axis/Scale/select logarithmic scale. I hope I am not being excessively pedantic :-) Give it a try; you can always reset to a linear scale. Again, being pedantic again, the logarithm of a negative number is imaginary. James Silverton. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Auto minimum on Y Axis
Hi - thanks for your reply, but the logarithmic scale doesn't help as it makes it go haywire. I think the fact that the variables on the x axis can vary so greatly it goes off the screen sometimes -- mattjenkins ------------------------------------------------------------------------ mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558396 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent - X and Y Axis Auto Scale for Chart | Charts and Charting in Excel | |||
Y Axis Auto Scale | Charts and Charting in Excel | |||
Auto Display of X and Y axis values for multiple charts in WKBK | Charts and Charting in Excel | |||
Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |