3
I have been doing some more complex work with Excel (different tabs/worksheets, etc.).
Now I have some charts from one worksheet that I'd like to kind of embed in the other worksheets for the purpose of comparing the chart of one situation with the original charts from the other worksheets.
There seems to be no actual possibility of pasting a chart in a way that when the original is changed (be it the data or the colors of the different series etc.) that the copies change automatically.
Thus, currently I find myself updating 5 or 6 worksheets each time when I change something in the original chart.
I see you can embed charts into Word and Powerpoint etc. Is a similar thing possible within Excel???
Sure, but when I add series or change something in the formatting of the original chart etc. it will not change in the copies. I want the copy to be completely linked to the original. Not just to the original data. – Marki – 2014-03-21T14:50:38.193