Find minimum value of a chart series

[Rudi]

How do I store the minimum value of a chart series in a variable. TX

eg: MinVal = Application.Min(ActiveChart.SeriesCollection(1).Values)

[HansV]

It looks like you answered your own question...

[Rudi]

You are right....I could have sworn it did NOT work when I posted it!!!! I think I did not have the chart selected...thats why!
I added code to check for this event!

TX again!

[Jon_Peltier]

Sometimes I have seen the one line command fail, so I generally do this:

Dim vValues As Variant
vValues = ActiveChart.SeriesCollection(1).Values
MinVal = Application.Min(vValues)

[Rudi]

Thanks for your valued input Jon. Appreciate it (and your website - which I reference often for charting tips and info.)
Cheers