In this lesson, I’m going to be showing you how to:
- COPY a chart from one worksheet to another worksheet in Excel
- Maintain the CHART LINK to the original data source
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Watch this tutorial directly on our YouTube channel and Subscribe
Thanks for watching!
Do you want to learn to create your own website?
If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.
CLICK HERE to read our review about this amazing learning platform, if you want to know more.
When you’re ready move onto:
Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel
Or go back to:
Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel
Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel
Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?
Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel
Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!
Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel
Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel
Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel
Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel
Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?
Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?
Lesson 24 – How to SORT data in ASCENDING order in Excel
Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel
Lesson 22 – How to RENAME a worksheet in Excel
Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel
Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?
Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?
Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?
Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?
Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?
Lesson 8 – What is the IF function, and how to insert it in Excel?
Lesson 7 – What is the ROUND function, and how to insert it in Excel?
Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?
Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?
Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?
Lesson 3 – Simple Subtraction Formula using Excel
Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel
Lesson 1 – Simple multiplication Formula using Excel
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor
I watched this tutorial on YouTube and thought it was very clear. I think what you are doing gives learners the opportunity to learn at a good pace. You do not rush your learners, well.. I certainly didn’t feel rushed! Many thanks for this Habib.
Thank you Ekufaa. I will never rush anyone, the pace is very important in education. Have you subscribed to our YouTube channel?
habib (ICT tutor)
Hi, Habib, This is LauenceG. from WA, You are on my internet, and I am following you. You said visit your website and here I am. This is really nice and I commend you on helping others out. Keep up the good work. I will leave here and visit your YouTube channel.
Be Safe and Successful!
Thank you very much Laurence, much appreciated. Hope my website and YouTube channel is very useful for you. Take care 🙂
Habib (ICT tutor)
Hi Habib,
Your explanation is amazing. Your videos and your site becomes a reference for me. Anytime, I have a query about excel. I refer to your videos for the answer.
You should continue your videos so that you cover everything concerning Excel.
Wishing you great success
Rania
Thank you Rania. I will continue with my tutorials till I’ve covered quite a lot on Excel. Then my plan is to do tutorials on Microsoft Word, Powerpoint, Access, Publisher and many other software. Take care
Habib (ICT tutor)
Hi
Thanks for this tutorial. I spent a few days last week trying to move a chart, so this couldn’t have been more timely for me.
I love your video too, and for me its the easiest way to follow your instructions. You really do make it easy to understand for someone like me who isn’t that skilled at excell yet.
Thanks again,
Judy
You’re welcome Judy – I’m very happy to help you. Thank you for the kind comment.
Habib (ICT tutor)
I have not been a great fan and user of Excel but I am sure that the knowledge will come in handy. The video is very clear and extremely helpful. It is very easy to undertand.
Thanks for a great post!
Joe Joson
Excel has a lot of benefits Joe, once you’ve gone through all my lessons, you will realise how much. Please start from lesson 1 to gain maximum benefit. Take care
Habib (ICT tutor)
Hello Habib, I look at your video and I find it very good make and explain. I like it and share and your post here has very good information for excel, I worked on excel platform for almost ten years and I just love this software to work with, it is very friendly and easy to understand.
Thank you for this info
Lyne
Thank you very much Lynne for your thorough feedback.
Habib (ICT tutor)
Habib, I love all your tutorials on excel. This is absolutely helpful. I have always found moving a chart to a new worksheet challenging. Shocking that you can achieve this simply with copy and paste. Quite interesting. Thanks for sharing.
You’re very welcome Chris – sometimes the easiest task seems like the hardest. Happy to hear it has been helpful and you are now able to copy a chart to a new sheet. Take care 🙂
Habib (ICT tutor)
Very clear and nice tutorial Habib! It’s been a while since I used excel and I seem to have forgotten many of the basic functionalities so your tutorials are really helpful. Keep up the good work!
Thank you Chuck – hope you’ve remembered how to copy a chart to a new worksheet and maintaining the link. Take care 🙂
Habib (ICT tutor)
Hi Habib, your video seems very well done and your post looks good overall. I am only wondering if the text could not be more descriptive and detailed. Otherwise you have a professional quality here that stands out and is very believable. Next time I need a tutorial on excel, I will definitely look here! Thanks! Joe
Thank you very much Joe for your feedback. I will be adding more descriptive text at a later stage, as at the moment my visitors are loving the video I have on there, and they are finding it so much easier to follow the lesson.
Habib (ICT tutor)