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 Mar 21 '14 at 14:50

You can use the Excel Camera Tool to take a snapshot of cells or charts. Once they are placed where you like, they will automatically update whenever the original is changed.

Here are instructions how to use it. It's a handy tool.

Note: When using it to take a snapshot of the chart, select the cells surrounding the chart in order to get the shot. Selecting just the chart doesn't work.

| improve this answer | |
  • That's slick! :) Why is that Camera buried so deep Microsoft?? :/ – Ƭᴇcʜιᴇ007 Mar 21 '14 at 15:14
  • 1
    Probably thought we'd abuse it. LOL – CharlieRB Mar 21 '14 at 15:15
  • The fact it updates the data while showing it on a 3D angle is crazy cool -- and almost useful. ;) – Ƭᴇcʜιᴇ007 Mar 21 '14 at 15:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.