Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

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

  1. Understand what is the PLOT & CHART AREA on a chart in Excel
  2. SHADE the plot area in a 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 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Or go back to:

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

22 thoughts on “Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel”

  1. Hey Habib,

    This is really great lesson that you have shared with us, in terms of the plot area in Excel and how you can use the plot and chart to structure your Excel page. There is so much involved in Excel all the different sections and in this lesson you really have to understand but for me it’s a challenge but it’s nice to see when you you do the lessons in stages how you can understand Excel more better as a great tool to use.

    Thanks 🙂

  2. Thanks Habib. This really is really helpful. I have noticed a few posts from you about excel and they have been a huge help when it comes to
    Mastering the confusing program that is excel. Keep up the good work mate.

  3. Thank you for another great excel lesson, Habib. Excel is definitely not my strong suit. But with your clear lessons, I am starting to get a handle on it. I do have a question for you. You mention you are an ICT tutor. What is that?

    • You are very welcome Amanda. You have come to the right site to strengthen up your Excel knowledge and skills. We also have a dedicated YouTube channel on excel and other Microsoft office software tutorials.

      ICT stands for Information Communication Technology, therefore I’m an ICT tutor. Hope this helps 🙂

      Habib (ICT tutor)

  4. Hi Habib and Rani,
    I am a fan of your website and channel. It is an amazing one and I recommend it to my friends. What I like most about your explanation is that each video focuses on one topic or function. This is the best way in teaching and this helps the audience to absorb the information easily and quickly. You focus on Excel that most people need in their job.
    Wishing you great success.

    • Thank you Rani, I agree with everything you have just mentioned. My aim is to spread free excel knowledge, so everyone can benefit from it.

      Habib (ICT tutor)

  5. Hi

    Thanks for another great tutorial.

    I’m really enjoying working my way through all your lessons. You’ve included some great tips here which will help me to get on top of this plot & chart area function.

    Your videos are great to follow because you stay with just one topic at a time.

    • Thank you Judy and you’re welcome. It is important to make the lessons specific to one or maybe two learning aims, otherwise it would not be effective. I’m an ICT tutor, hence am very aware of psychology of learning. Take care 🙂

      Habib (ICT tutor)

  6. Thank you very much. I was so confused about ‘plot area’ in Excel. Now it’s so clear and I wonder why I ever had problems with it.

  7. What I really like about your videos is they are short and focused in one or two things at the time. It makes so much easier. We know excel has endless possibilities and it can get very tough sometimes. It is good to learn it gradually, without getting overwhelmed. Very good video. Well done and keep doing the good work.

    • Yes, Excel is a very powerful software. This is why breaking down the learning in smaller chunks is very important. I’m a qualified tutor and am very aware of this and I will always make all my video lessons understandable and easy to follow. Take care 🙂

      Habib (ICT tutor)

  8. It seems like there is so much capability with Excel, and learning about plot and chart areas is information that I could see being very worthwhile to have. Thank you for clearly explaining and describing these topics in a way that is understandable and enjoyable.

    • Excel is a very powerful software Michael. I will be having many more lessons here on Excel and other Microsoft Office suite.
      Happy to hear you found learning about the plot and chart area in excel enjoyable.

      Habib (ICT tutor)

  9. Wow, I was venting about how frustrated I was with Excel just yesterday morning! My knowledge of the program is super basic, so ‘m glad I found your site – all of your lessons will be an excellent resource for me! Thank you for all of the info!

  10. Hi there,

    This plot chart area function is really valuable for structuring and designing charts. What I love about latest Office version is that they offer suggestions on how to design it. But learning how to do it yourself is always the way you should learn, at least in my opinion. Some great little tips in this video also that I didn’t know.

    Thanks as always.

    • Hi Sharon, I agree with you learning everything from scratch is the best way to go. Of course you will need education from a qualified tutor like myself to help and guide you through. Microsoft is getting better and better. Thanks and take care

      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap