copied & paste a chart from one worksheet to another worksheet - wont refresh

[Mahmud]

Hello

I have copied & paste a chart from one worksheet to another worksheet with in the same excel doc. (excel 2010)

now, when i update the source chart with new data, the other chart does not refreshed with the new data.

please help.

thanks
MK

 

[vletm]

Have You checked 'other chart's Data Source?

 

[Shteven]

Did you try Paste Special >> Paste Link >> Microsoft Excel Chart Object ?

 

[Mahmud]

Hello vletm

the 'other chart's data source does not change. hence it is still showing as per that data. (i keep on adding months on the right column of the source data every month and the previous month's data does not change).

in the original chart, i update the range of the data each month, adding new month. But it does not update the 'other chart'?

Hello shteven

i tried paste special option, but it does not give me the option to paste link!
i was doing Alt>E>S but I can't click on that radio button!

thanks