Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

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

  1. CHANGE the CHART from one TYPE to another in Excel
  2. Change a column chart to a pie chart 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 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Or go back to:

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

30 thoughts on “Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel”

  1. This is an awesome post with easy to follow video training, I bookmarked your article for future reference as well. I would not want to lose out on any of your training, so I was wondering what is the best Word Processing program and are there any free programs I can download that you know of?

    Jeff

    Reply
    • Hi Jeff, thanks for bookmarking our site, and don’t forget to subscribe to our YouTube channel, which is dedicated to all my ICT tutorials.
      The best word processing software is Microsoft Word, but there is a free software that comes with windows, called WordPad, which does all the basics of any word processor. Hope this helps. Take care

      Habib (ICT tutor)

      Reply
  2. Who knew it was that easy to change a chart to a pie chart. I will need to bookmark
    this lesson. I look forward to the next lesson to learn how to incorporate the labels
    onto the pie chart.
    Excellent teaching! Thank you.

    Reply
    • Thank you very much Teresa for your feedback. Quite simple when you know how, and having myself explaining it to you does help 🙂

      Habib (ICT tutor)

      Reply
  3. Wow…Why don’t I watch this video earlier? My boss always asks me to make a chart and he always changes his mind for the type of chart. Since I don’t know how to change the type of chart, I always make a new chart from A to Z. Now, thank you Habib, I know a faster way to change the type of the chart. Thank you so much.

    All the best,

    Alex

    Reply
    • You’re welcome Alex. Now you can impress your boss by creating or changing charts very quickly. You can even show your boss how to do it – you might impress him/her enough to get a rise in your salary 🙂

      Habib (ICT tutor)

      Reply
  4. Thank you for these specific and detailed steps.

    I use excel for many of my business calculations and I have had issues with turning column charts into pie charts, Thank you for this.

    Reply
  5. Your videos are very easy and straight-forward, I am on Excel following your steps and it is really convenient for when I want to use the application for my articles. Thank you for these great tools they are very useful! Peace & Blessings.

    Joshua

    Reply
  6. Thanks for another great lesson! Changing from one type of chart to another in Excel looks so easy when you explain it the way that you do. I quite like the options that are available when selecting different charts, as well – something that I was not aware of before this lesson.

    Reply
    • Thank you Michael. Happy to have helped you with changing charts. It is quite fun and I recommend you experiment changing to all different kinds of charts excel has to offer.

      Habib (ICT tutor)

      Reply
  7. I have a confession to make. Excel scares me. I’m an administrative assistant and have to use Excel but it’s never made sense to me so every time I use it, I have to google instructions on whatever it is that I’m trying to do.

    And now…on this magical day…I found your site with all the instructions all the instructions in one place! And all the links on one page so I don’t even have to search your site? This is a game changer for me! I’ve bookmarked this site and subscribed to your YouTube channel.

    Thanks for doing this!

    Reply
    • That’s great Cynthia. Our site is very easy to navigate, in particular from one lesson to another in a sequential form.
      Thank you subscribing to our YouTube channel – you will love it! I have big plans to create hundreds more tutorials covering all software of Microsoft Office and other software too. Take care

      Habib (ICT tutor)

      Reply
  8. Hello Habib,
    Reading your posts and listening to your videos equal a fully comprehensive course in Excel. Your site is my best reference if I have any query about any function or topic regarding Excel. Besides, Your explanation is perfect.
    Wishing you great success
    Rania

    Reply
    • You’re feedback is very valuable to us Rania – when I read a comment like yours, it makes me realise my effort and time is being rewarded as I’m helping so many people out there to gain knowledge on excel. Take care

      Habib (ICT tutor)

      Reply
  9. Thank you, for such a detailed explanation on moving charts from one to another. I am not so great with excel, but I was able to complete it without a problem.

    Reply
  10. This is a great lesson. But for folks who are not currently involved in anything using Excel, it might be great if the lesson will involve a practice exercise using Excel and be able to save this work somewhere. Go back to it and use the next lesson…if you know what I mean?

    Application of the software in a practical way and could be done long term and could re visit it and continue with the rest of the lessons you have listed here.

    Thanks.

    Joe Joson

    Reply
    • Hi Joe – unfortunately I haven’t got this facility on my website for anyone to save their work on my site and then continue from where they left off.
      However, my lessons are done as a series in a sequential manner, so that when you start from lesson 1, you simply have to continue with the lessons and each lesson builds on the same spreadsheet you start creating in lesson 1. Hope this information is beneficial to you.

      Reply
  11. Thanks so much for this tutorial! It is fantastic— truly. I struggle a great deal with using Excel. It was something that held me back when I worked as an Admin for an engineering company. Charts were especially difficult. I wish I had this video back then! It would have made my life so much easier!

    As a freelancer though, I will need to use excel once in a while to keep track of finances and things. So this tutorial and website will be exceedingly helpful. I will be sure to pass this on as well!

    Reply
    • That’s great to hear Darcy. You have found us now, so please remember to bookmark our site. Also we have a dedicated YouTube channel, where I have all my excel tutorials and may more tutorials are to come yet. Feel free to subscribe to it. Take care

      Habib (ICT tutor)

      Reply
  12. Hello Habib, I just love your website, the way you write and explain it, I find it easy to understand and it helps me with my own site. Very good information. Thank you
    Lyne

    Reply
  13. I absolutely love visiting you website! I learn something new about excel every time. I might need to start from the beginning to truly grasp everything because understand how to use excel is very important for most jobs! Thank you for the wonderful tutorial!

    Reply
  14. Thank you for this video! I learned a lot about how to use excel to create and change the type of charts. I want to use this to create some charts or better say pie charts for my blog. However, there is a question that came to my mind after watching this video. I want to know after I create the chart, how to add more information to it, and after I have done all that how to convert it into a photo so I can add it to my blog post. Is that possible using excel?

    Thank you again for this great lesson!

    Reply
    • Thank you and you’re welcome Mohammad. You can add more information to your chart by watching the next lesson: Lesson 38

      You can easily then save the chart as an image. This can be done many ways. I will do a tutorial on this soon, but for now I will add it onto my list of tutorials to do. So watch out for that and take care.

      Habib (ICT tutor)

      Reply
  15. Great lesson again!!! This article How to CHANGE the CHART from one TYPE to another in Excel is so helpful. My husband is always looking for answers to excel challenges so I will be sure he has this information. Best wishes.

    Reply

Leave a comment

Share via
Copy link
Powered by Social Snap