i need to create a chart from data from one workbook in another wo

M

Marko30

hi
new to excell so please be kind. i need to create a series of charts from
different sets of data in one workbook, and have the charts show in another
seperate workbook, and update automaticly when the data changes in the first
workbook.

i know how to create charts, its just that i can't get it linking from one
workbook to another

please help

Mark
 
B

B. R.Ramachandran

Hi,

An easy approach would be:
Make the charts in the workbook containing the data. Cut and paste those
charts into a new workbook. The charts are still linked to the original
workbook. If you make changes in the data, the charts would reflect those
changes.

Regards,
B. R. Ramachandran
 
Top