Use Relative Cell References for Chart Data Range

Hi,

I'm using an XY scatter graph, and need to copy the same graph and its range data multiple times and would like the reference source data for each graph to change relatively. When I make the copy of the graph and source data and paste elsewhere - the graph still references the source data of the original graph. The source data seems to turn into absolute but even if I remove the $ from the formula, it simply reappears.

Thanks for your help.

Emer

are you trying to look at different views of the same data - if so use offset to define start and end points, then copying will enable you have a load of different graphs because you will only need to change the start and end reference points