Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

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

  1. Understand what is a CLUSTERED column chart in excel
  2. Insert a CLUSTERED column chart in excel
  3. Understand what is an EMBEDDED 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 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Or go back to:

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

30 thoughts on “Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?”

  1. Hi Habib,

    Thanks for today’s tutorial. And, it’s comprehensive and easy-to-learn. I used to see these charts in my managers’ sales report, but I never thought I need to learn how to make one someday.

    With your step-by-step explanations, I learned how to make one clustered column chart and adjust the color, style, and text font to make it concise to read. So, thank you so much for helping me learn one more excel skill today.


    • You are welcome Matt. Glad to hear you have learned from my tutorials. I have many more Excel tutorials on my YouTube channel. So, check if out if you like.

      Keep up the great work.

      Habib (ICT Tutor)

  2. Great tutorial , and very informative. The content was easy to understand and apply. My son does a lot of work on excel and I’m sure he will find some of the information quite useful. Thank you for this , will definitely pass it on. All the best

    • Thank you felicity – my lessons will be perfect for your son. Please get him to start from lesson 1 and complete them all at his own pace. The lessons are sequential, so starting from lesson 1 is important. Also ask your son to give me his feedback too, will love that 🙂

      habib (ICT tutor)

  3. Thank you for this wonderful, detailed tutorial. Every time I watch your videos I learn something new. I never knew how to insert a clustered column chart until I watched it. Your website is very neat, helpful, and efficient. I wish all the best fo you and your success!

    • Thank you so much Aminah for your detailed feedback. I want to keep our website neat and clutter free so everyone can navigate easily. Happy to hear you learnt about the plot area from this post. Take care

      Habib (ICT tutor)

  4. Hi Habib,
    Thanks for making it so simple and clear to understand. Initially, I had no clue of a embedded clustered chart, but after watching the video, I said this is very simple. Love your explaination and I will continue watching your other lessons too.
    Great tutorial.


  5. Hi Habib,

    Thanks again for another really clear and easy to follow tutorial.

    I’m enjoying working my way through all your lessons. I had no idea I could do so much with excel.

    I’m no expert, but I’m starting to feel like this is something that I can learn to use properly.

    Thanks again!

    • You’re welcome Judy – my lessons will make you an expert, and because you are understanding an connecting with everything I’m saying you will learn a lot faster. You will soon become an excel pro 🙂

      Habib (ICT tutor)

  6. Thanks for another comprehensive tutorial. I haven’t stumbled upon content as good as yours explaining everything step by step.
    Looking forward to see your next post. What will it be about?

  7. I had no idea all that you could do in Excel…I learned something new today. As an elementary school teacher, I mostly use Word and Youtube videos can be very engaging and powerful to my students. I like how easy your Excel Youtube videos are to watch and learn. Not distracting or confusing, especially to someone who is not very knowledgeable with Excel. Thanks and keep up the good work!

    • You’re welcome Dana. Feel free to use my YouTube channels videos in your school with your students. My plan is to create video lessons on the full Microsoft suite of programs, such as Word, Powerpoint, Publisher, Access etc. Thank you for the lovely feedback 🙂

      Habib (ICT tutor)

    • Thank you Tommy. Currently I’m doing the excel video lessons. But my plan is to do it on all the Microsoft Office 365 suite, such as Word, Powerpoint, Access, Publisher etc. We also have a YouTube channel, which you should check out.

      Habib (ICT tutor)

  8. Another very useful tutorial Habib. When I’m searching YouTube for some of these how to type lessons I’ve come across your channel on a number of occasions so your putting out some good content. I’m still fairly average at Excel but your certainly helping me get there.

    Thanks – Jason.

    • Happy to of service Jason – I’m making good quality video contents and this is why I’m ranking high and YouTube is showing you my videos when you’re searching for “How to” type videos. My aim is to always create good quality contents here and on my YouTube channel 🙂

      Habib (ICT tutor)

  9. Another great lesson!

    I’ll be honest, I now realise there’s much more to making a spreadsheet than I realised, which has in turn made me realise there’s so much more potential!

    I’m surprised you’re giving this information for free, to be fair!
    This seems like prime stuff to put into a paid course or program! (I’m glad it is free, though, obviously!)

    Looking forward to more, though I know I’ll need to go back to the start again, lol


    • Thank you Tony and am happy you’re learning from my lessons. My lessons are free because I want to educate everyone around the globe for free with my video lessons. Education should be free where possible.

      I want everyone to help me in my mission to reach out to everybody especially to those who cannot pay such high fees for these courses. My lessons would normally cost hundreds of GBP, but I want to give it for free.

      Please share my site and YouTube channel, where all my FREE lessons are. Thank you

      Habib (ICT tutor)

  10. Thanks for this informative post, you explain everything very clearly and in detail. I’m sure you’ll help many other people to use Excel in more advanced manner. I will definitely subscribe to your channel.
    Keep up the good work!

  11. Hi Habib,

    Thanks ever so much for this tutorial.

    I must admit it has been many years since I’ve used Excel on a regular basis, but I do like to create graphs and charts for business purposes.

    This is an easy-to-follow and thoroughly informative tutorial, which of course makes my job far easier.

    Although this tutorial covers embedded charts, I note you have mentioned that we can use it as a separate chart worksheet. I think that method would be preferable for me and the type of information I like to produce.

    Thanks once again for your all your great videos and I am now subscribed to your YouTube channel as well.


    • Happy to help and thank you for subscribing to our YouTube channel Partha – welcome on board to our YouTube family.

      Now coming to your question – you can move your chart to a separate worksheet on its own, instead of having it embedded next to the data source. It does have its advantages and the chart is more clear to present. To do this, click the chart and select move chart on the top right, then select new sheet to move to. Hope this helps you out. Take care

      Habib (ICT tutor)

  12. Wow! Love how this is like ‘how to insert cluster column charts in Excel for dummies!’ You make it all look so easy Habib. 🙂


  13. I have studied Excel in the past but did not know about clustered column charts until watching your video today. I like the location of the chart placement, as well as your reminders to highlight the correct block of data initially. Thanks for teaching me something new today.

    • You’re welcome Michael. The selection of the data is utmost important, otherwise the chart will not be created. Happy to have taught you something new today 🙂

      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap