Thanks for your reply Robert but I apparently don't understand. When I double click on my embedded chart, I get the "Format Chart Area" box and it does not have the data series anywhere. If I go to the Menu Option "Chart Data" where I can actually see the data Series, if I put my cursor in either of the "Data Range" or the "Value" box (where I see the actual absolute range it is using) & hit F9, nothing happens.

What am I doing wrong?

Thanks for your help.