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

Filtered view of Visio Chart 0
Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating Network Diagram using a Chart SW integration 0
Creating a Chart on form from selected data in query. 0
Macro to determine min/max values of column 3
Conditional Formating: MAX & MIN 3
MAX and Min value 2

Top