How to link excel charts to other spreadsheets

[thisguy23]

Hello,

I have to enter data into a spreadsheet daily and update a line graph with the data for 10 different production machines. I want to place the charts on their own separate excel file that way they can be easily viewed without the data next to them. I tried copying and pasting the graphs to another excel spreadsheet, but when I update the graphs on the original excel file the data does not change on the one I copied the graphs to. I use the select data range option to update the line graph data. Basically, I just want both graphs to update at the same time on both spreadsheets, but the links don't seem to update. How would I link the graphs so that both update across files?

[VitoBdG]

Don't you have the manual formula calculation turned on by a chance?
You may also have 2 excel applications working and those charts opened in the other application than the actual database.
Try switching to automatic or press F9.

I have my charts in different files and they seem to work perfectly.

Regards'

Vito

[luv2glyd]

Also, you have to have the original data sheet as well as the sheet that contains your new graph open at the same time so that the graph updates with the new data.