Thread
:
Auto x range start value, xy charts
View Single Post
#
4
Don Guillett
Posts: n/a
better
x=SMALL(d1:d100,COUNTIF(d1:d100,0)+1)
--
Don Guillett
SalesAid Software
"Don Guillett" wrote in message
...
see if this idea helps
Sub setmin()
x = Application.Min(Range("d1:d12"))
Sheets("sheet4").ChartObjects("Chart 3"). _
Chart.Axes(xlValue).MinimumScale = x
End Sub
you may want to change x=
x=formulaarray."=MIN(IF(d1:d120,d1:d12))"
--
Don Guillett
SalesAid Software
wrote in message
oups.com...
I have several Excel xy charts plotting data that updates
automatically.
The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600.
I want the chart x values to start at the lowest x value in the data,
but it actually starts at 0 for all values up to 160, then does what I
want for higher x starting values.
I have the x axis auto button selected.
Can anyone tell me how to stop the minimum value defaulting to zero?
Excel 2003 and Windows XP.
Reply With Quote