When I edit the chart's data series it reverts back to absolute reference
$A2$22.
I couldn't find the answer in the excel options or in help.
Thanks for your assistance.