Min and Max Values on Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 23 Jan 2006 14:36 GMT

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

Reply to this Message

Tom Ogilvy - 23 Jan 2006 15:17 GMT

go to the source data and do

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

Signature

Regards,
Tom Ogilvy

> Hello,
> Is there a quick (and easy) way of determing the minimum and maximum values
[quoted text clipped - 4 lines]
>
> Bill

Reply to this Message