In this lesson, I’m going to be showing you how to:
- Insert a line chart with markers in Excel
- Select non-adjacent data in Excel
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 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel
Or go back to:
Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel
Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel
Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!
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, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor
This step by step video is just a godsend for me. Thank you, you saved me a lot of work and stress of trying to figure out how to create a line chart with markers. You’re explanation is excellent.
You’re very welcome Andrea. Happy to have helped you and thank you for the compliment.
Habib (ICT tutor)
As always your content hits the spot and is very practical.
I have been using excel on google and found many of your tutorials helpful.
Do these all work for excel that is on google?
Hi Thabo, Google sheets is somewhat similar to Microsoft Excel, but nowhere near as comprehensive. But you can do all the basics, the same as MS Excel. My tutorials and lessons can be carried out using Google sheets too. Take care 🙂
Habib (ICT tutor)
Hi Habib. This is great! Something that could be considered quite complicated to an Excel novice is actually very simple to do. In this day and age, it´s also good to know how to create a graph which shows “trending” information. Thank you for much for the lesson!
Hi Susan, you’re welcome and thank you for you comment.
Habib (ICT tutor)
Habib,
Your lessons are clear, concise and easy to understand. Your video and voice are also both clear and done very well. I do consider your lessons to be very professional. Well done.
Courtney-
Thank you Courtney for the compliments. I will always try to make them better, so everyone can love them even more 🙂
Habib (ICT tutor)
Well done, Habib.
It is a very useful video. I know how to select non-adjacent data and create a corresponding line chart now. Thank you so much. Together with the video of Lesson 37, I’m now able to change a line chart to another type of chart. In the nutshell, your Excel video series can really help many people to better use Excel software. Keep it up.
All the best,
Alex
Thank you Alex for your encouraging words for our visitors to read and be motivated by. I have created these lessons as a series so everyone can complete them in a sequential manner to learn all aspects of excel. Happy to hear you’ve got the charts mastered now. Well done 🙂
Habib (ICT tutor)
I have never been good in graphs in Excel, but now I understand the steps.
Is it an idea to put some screenshots beneath the video with a little bit of text?
Anyway, the video is helpfull in itself.
Thanks, Habib
Thanks for you feedback Hannie, and I will be adding more textual data to go with the video, but for now the video is doing the job and everyone is loving it. Happy to hear you now got an understanding of how to include graphs in excel.
Habib (ICT tutor)
Hi,
Lots of great information and I feel like I’m slowly getting to grips using Excel. I’ve checked out some of your previous lessons and am happier understanding the difference between formula and function in Excel now which struggled with before.
Thanks for sharing.
You’re welcome Mark and I do recommend you start from lesson 1 to make the most of my lessons. Thanks
Habib (ICT tutor)
Hi Habib! Thank you for today’s lesson. I love to attend your lesson as it’s short and sweet. Easy to learn bit by bit without having a overwhelm feeling. Help me to absorb and remember easily.
You’re welcome Janet. Short lessons is the way to go to understood a particular feature of excel correctly, in todays lesson it was all about the line chart.
Habib (ICT tutor)
Very interesting and simple! It looks like you know a lot about Excell!
Yes I do Isabella, I’m an ICT tutor by profession. Hope you have understood everything about line charts. Take care
Habib (ICT tutor)
Another useful Excel trick Habib. Your site has been a great reference guide for me given that your working your way up through more detailed functions as the lessons progress. You’re typically one of my first go to sites when I need to work out an Excel issue so thanks again for sharing.
Jason.
You’re welcome Jason. Thank you for your comment. Please do start from lesson 1 and complete them all to have a comprehensive knowledge of Excel.
Habib (ICT tutor)
Wow Wow!
This is the website with all information about excel.
finally found it, all useful tips and training.
Well, I guess this is the right place.
Thank you Yosef, happy to hear you like it. But do start from lesson 1 to make the most of these sequential excel lessons.
Habib (ICT tutor)
Ooh I just understood where I’ve been wrong. haha all clear now!
Thank you Habib so much
You’re very welcome Tanya – happy to help 🙂
Habib (ICT tutor)
Dear Habib.
Thank you very much for your fantastic article that has helped me to manage my company bookkeeping.
Kind regards,
Andrey
You’re welcome Andrey. I am more than happy to have helped you. Take care
Habib (ICT tutor)
Hi,
Thank you for this 5 mins walkthrough video and for all these steps by step excel tutorials.
I subscribed to your channel as well and can’t wait for your next tutorial. I really want to know how to use Excel properly and hope I found my way.
Thanks
You’re very welcome Sebastian. The next lesson will be available tomorrow at 12pm on our YouTube channel. Happy to have you on board as a subscriber to our YouTube channel. Take care
Habib (ICT tutor)