setting up a form on sheet 1 & copying to other sheets, graph still points to sheet 1

suppose you have on sheet 1

column a is names
column b is total sales
column c is arrivals
column d is formlas =b/c

select column a and column d, alt F11 to get a chart.

the chart shows the figures from sheet 1.


select all, copy

go to sheets 2, 3, etc, paste

go to sheet 1, fill in the sales and arrivals in b and c. graph correctly shows each name with sales.

go to sheet 2, fill in sales and arrivals in b and c. D. is correct for these figures.

graph shows sheet 1's figures, not sheet 2....

theres 52 sheets, i dont want to have to individually set up the chart on every one of them..

click on graph and select 'edit data' can see its tied to sheet 1

help