Macro, Maximum and minimum part of chart

[Nitha120]

Hi,
How do I find the maximum and minimun x-value from the chart? I made this graph with excel and i want to write a macro that would extract the maximum value and minimum vlaue and put into a table.

Any suggestion would be great!

 

[SkipVought]

Hi,

Wouldn't it be easier to look at the SOURCE DATA ranges to fin the min/max values for any series?

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}