Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Paste link

Resolved · Low Priority · Version 2010

Reply Tue 12 Jul 2011, 16:44Delegate Samantha said...

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

For upcoming training course dates see: Pricing & availability

Reply Wed 13 Jul 2011, 09:30Trainer Stephen said...

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

Reply Wed 13 Jul 2011, 16:18Delegate Samantha said...

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

Reply Thu 14 Jul 2011, 16:43Trainer Stephen said...

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

Reply Thu 14 Jul 2011, 17:05Delegate Samantha said...

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.

Reply Fri 15 Jul 2011, 08:40Trainer Stephen said...

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.

Excel articles

· Tips to Facilitate Printing of Excel worksheets
· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· A Picture Is Worth A Thousand Words (Or Numbers)
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Want To Use Excel To Calculate Your Mortgage Repayments?

Please browse our web site to find out more about
excel/course/london and other Microsoft training courses.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips