View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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