Does just referenceing the other workbook not do it?

If you need to look at where the source data comes from...

Right click in the chart somewhere and you should see the option "source
data" click on it and you will see you where the data is sourced from for
each element of the graph.

Any use?

Andrew
www.jmdata.co.uk

"Charlene" wrote in message
...
Can you please tell me how i can create a chart in one workbook using data
from anothe workbook. I also want to link this chart to the table so it
gets
updated automatically