View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default 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.