Hi, I think that you can get what you want by converting the serie
ranges to arrays - this gives a frozen chart.

a) click on the data series of the chart (actually on the line or bar)
- this will show the range in the formula-edit bar
b) click on the formula
c) Press F

--
Message posted from http://www.ExcelForum.com