paste link

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Paste link

Paste link

resolvedResolved · Low Priority · Version 2010

Samantha has attended:
Excel Advanced course
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course

Paste link

how can you paste link a graph - to update automatically when extra data is added

RE: paste link

Hi Samantha

Thanks for your question

Can you clarify for me the following

1. Are you copying the chart from Excel into another application?
2. If so what is tha application (Word, PowerPoint etc)

Thanks

Stephen

RE: paste link

Hi Stephen,

Sorry maybe i've got my wires crossed. I was under the impression that I could do something that would automatically update the chart when the infomation was changed?

Regards
Samantha

RE: paste link

Hi Samantha

Sorry, I'm a little unclear.

You original post mentioned "paste linking". This is a technique were you can copy something into another file so that if the source changes then the copy will as well. If this is what you want then the method changes slightly if you are copying into word or powerpoint.
Is this what you want to do or had you something else in mind?

Thanks

Stephen

RE: paste link

apologies for the confusion! I currently update graphs on a monthly basis taken from information from various spreadsheets. the trainer told me that i would find paste linking very helpful - but it appears i may have got cross wires.

RE: paste link

Hi Samantha

OK this is simple enough

The procedure is as follows

1. Select the chart and copy it to the clip board
2. Open the file that where you want to paste the chart
3. Click on the clipboard button, which is in the clipboard group on the home ribbon
4. Select paste link from the resulting menu. (This is the clipboard icon with the chain)

Your charts will now automatically update

Hope this helps

Regards

Stephen

Thu 21 Jul 2011: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.06 secs.