Min and Max Values on Chart
 

Hello,
Is there a quick (and easy) way of determing the minimum and maximum values
of data points on a chart? I have multiple lines on a chart and want to be
able to find the min value and the max value.

Thanks.

Bill

Min and Max Values on Chart
 

go to the source data and do

set rng = <source data range
dblMin = application.Min(rng)
dblMax = Application.Max(rng)

--
Regards,
Tom Ogilvy


"Bill" wrote in message
link.net...
Hello,
Is there a quick (and easy) way of determing the minimum and maximum
values
of data points on a chart? I have multiple lines on a chart and want to
be
able to find the min value and the max value.

Thanks.

Bill