Hi

I have a graph which I do for each Month

Jan Graph (tab) Jan data (tab)

each month i copy/re-name this to make it Feb Graph, Feb Data, Mar
graph etc.

However is there any quick way of changing the whole graph and data on
the graph to read from a differenct sheet?

I am having to manual changed all the data boxs on the graph (=Jun!$B
$30) just to read July etc

Any ideas???

Linexe