Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

In this lesson, I’m going to be showing you how to:

  1. Adda data labels to charts in Excel
  2. Add percentages and values to charts in Excel
  3. Change the colour of the segments of pie-charts 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 39 – How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Or go back to:

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 (£) 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

14 thoughts on “Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel”

  1. Hi, Habib:

    Adding data labels and changing colors of charts in Excel are very well demonstrated in this lesson. Excel is so powerful and yet you are able to explain so clearly how to utilize it. Thank you for this great lesson!

    Reply
  2. Thank you for another amazing tutorial! Its extremely well organized and I loved how you used visuals. I will recommend your website to my friends who are learning all about Excel at the moment!

    Reply
    • Thank you for the beautiful compliments Aminah. My aim is to have everyone visiting our site and YouTube channel to learn all about Excel and the other Microsoft Office software. So thank you for telling your friends, much appreciated.

      Habib (ICT tutor)

      Reply
  3. Hello Habib,
    I believe honestly that this is the best channel for teaching Excel. It is also wonderful because each lesson is accompanied with a video. This helps to make the explanation clearer and easier. Wishing you all the best!
    Rania

    Reply
    • Thank you very much Rania as always. You are our regular visitor to our site, and I always look forward to receiving a comment from you after you have watched the latest lesson on Excel.

      Habib (ICT tutor)

      Reply
  4. Wow — I never stop learning here at Lifestyle Tips & Hacks. Excel is such a difficult program for me, and I LOVE that I can come here and find out everything I need to know. It is my one-stop-shop for helpful office skills! I hope to put Excel on my resume under the “skills” category very soon.

    I am a little embarrassed to say that I knew nothing about labels in Excel until now — but you learn something new every day right?!

    Thanks again.

    Reply
    • You certainly do learning something everyday Darcy. Learning is for life. Hope you have bookmarked our site and don’t forget we also have a YouTube channel dedicated to all the video lessons tutorials. Take care

      Habib (ICT tutor)

      Reply
  5. Hello Habib,
    another great lesson in Excel. Proper labeling is of great important and adding colors makes graphs so much easier to read. And it’s really not hard to learn how to do it. You explain it so calmly and patiently
    Thank you so much!

    Reply
    • Explaining calmly and with a lot patience is so important in my profession – otherwise students will not learn effectively. Take care

      Habib (ICT tutor)

      Reply
  6. That’s a great informative tutorial, thanks! Believe it or not, I’ve actually had lots of trouble correctly managing the data labels, as I’ve just recently finished my bachelor’s paper.

    I think I’ll also go through your 37 lessons slowly, checking if my knowledge has missed some useful tips and tricks.

    Thanks again!

    Reply
  7. Hi Habib,
    Excel is for me the best friendly and easiest software to work with when you know about it. It does everything you want. I worked in a mill in 2000 and I had to organise the schedule for 147 employees and 25 machines. I took a spreadsheet of excel and added some formulas and excel software did all the work for me. So let me tell you when people know how to work with excel it is one of the most easiest software to work with.

    Reply
    • That is great information to share. You are right about excel, it does automate a lot of tasks for us when create and set it up correctly.

      Habib (ICT tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap