Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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???

share|improve this question
    
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 at 14:50

1 Answer 1

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.

share|improve this answer
    
That's slick! :) Why is that Camera buried so deep Microsoft?? :/ –  Ƭᴇcʜιᴇ007 Mar 21 at 15:14
1  
Probably thought we'd abuse it. LOL –  CharlieRB Mar 21 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 at 15:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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