Macro to grab data from a chart

[Curt J]

I would like code that can grab the value set from a series within a chart.

The sheet that I would like to grab values from is titled "Benchmark Comp
Chart". There always exactly 1 chart on that sheet, but the location and
size of the chart varies. The chart always has 2 series, one named "Account"
and one named "Benchmark" The values are always numbers, and there are
always exactly 7 numbers within the set. An example of the set:

={4.946,9.917,12.72,26.76,11.22,14,20.43}

Could you put the individual values in cells J1:J7 of the sheet titled
"Benchmark Comp Chart"? Ideally, I would like to run this macro from a sheet
titled "Misc." and then end with my screen looking at the "Misc." sheet.

Thanks,

Curt J