View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Stacy35216[_5_] Stacy35216[_5_] is offline
external usenet poster
 
Posts: 1
Default ActiveChart.Axes(xlValue).Crosses = xlMinimum


This is just a regular scatter plot, log scale.

I can't specify a crossing point because the "bottom" of the chart
depends on the data entered - the scale changes as needed.

Oh, well maybe I can by choosing the crossing point depending on the
least y-value of the data set. I'll try that. I'm just miffed that I
found the command to do exactly what I want to do and it won't work.

xlMaximum was the first thing I tried - it also put the x-axis at the
top of the chart.

Thanks for the input, though. If there's not a better way I'll just
write some code to find the what the "bottom" of the chart will be and
then force the crossing at that point.


--
Stacy35216
------------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...o&userid=15952
View this thread: http://www.excelforum.com/showthread...hreadid=396285