Graphs/Charts by country. Same Graph, different Source Data
 

Hi

I have sales information for 5 countries, each on separate sheets ( the
sheets are identical in format) . I have made graphs for the first country,
and I want to copy them to the other countries, and change the references to
pick up the right country information. Is there a quick way of doing this or
do i have to go into source information for each series for each graph and
change the sheet( country ) reference

I asppreciate any answers to this as atthe moment I've spent the better part
of a day changing sheet references

Rgds

Dan