Min and Max Values on Chart

B

Bill

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
 
T

Tom Ogilvy

go to the source data and do

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to determine min/max values of column 3
MAX and Min value 2
Conditional Formating: MAX & MIN 3
Scroll bar - to increment btwn MIN and MAX value. 3
ScrollBar - set MIN/MAX cell value 2
different value for setting with breakpoint vs regular running code 3
Setting Chart Min, Max and other scaling 4
Adjusting scale of an adjsuting chart 1

Top