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
