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
|