Video Lesson: Creating and Designing Charts

Excel has very powerful charting capabilities, which many users do not take full advantage of. This lesson goes over a few of the types of charts using some example data.  Here is a quick summary of what is in the lesson:

– How to use the Insert Chart feature for Line, Pie, and Column charts.

– Formatting/editing chart axes, data labels, legends, data series, and chart titles.

– Detailed introduction to Sparklines (which allows for charts within individual cells).

Make sure to download the Chart Lesson workbook to follow along with the video!!

This entry was posted in Workbook/Reference Lessons. Bookmark the permalink.

20 Responses to Video Lesson: Creating and Designing Charts

  1. Anonymous says:

    Much appreciated!

  2. Anonymous says:


  3. Carolyn says:

    Once again fantastic job explaining everything clearly Ben!

  4. Anonymous says:


    i am not able to find the Chart workbook. Is it part of the same Master workbook or is it a different workbook. Could you please provide me the location of the Special chart workbook.

  5. andi says:

    Thank you so much!
    Sparklines is cool, i didn’t know about it

  6. Anonymous says:

    great is the only word that i have at this time.

  7. Kimberly says:

    Thank you. I recently took a Proove it exam for a recruiter and realized that I am so behind on my MSOFFICE skills. I wish I had viewed these lessons prior to taking the test. Now I am prepared for the next recruiter!


  8. JC says:

    Your session were very informative and easy to understand. Thank you very much. However, I was looking for a solution to a pivot table drill down question. How to customize the drill down output. For example, the Revenue number in the pivot table is 10,000 which is made up of 60 rows of detail data with several columns of data. I want to only show the customer names (only once and the total for that customer). Any idea how to do this?

  9. rovingrachel says:

    Thank you so much for your tutorials!! I have to brush up on Excel very quickly for a job application and I’m amazed by how much I’ve picked up in the past few days watching your videos. So grateful!

  10. Anonymous says:

    Thank you, very useful. Kate, Prague

  11. Phillip says:

    My version of Excel doesn’t have a “Sparklines” section under the Insert tab. Are there any other alternate ways to input a sparkline?

  12. Anonymous says:

    Great tutorials! The problem I’m having is this video is automatically restarting at 6min on every browser I use. I can’t go past that point to see the rest of the tutorial unfortunately.

    • Hi there,

      Unfortunately I can’t recreate the problem you’re having. The full video loads on my end, and I am able to skip throughout (including past the 6 min mark and to the end).

      Maybe it was a hiccup with vimeo?

      Hope it starts working for you!


      • Chris says:

        Seems to be working today!

        Thanks again, these are extremely easy to follow and I’ve already used some of the techniques you’ve taught to reduce my workload significantly (Especially PivotTables). Very grateful for your work!

  13. Anonymous says:

    I am from Pakistan, I liked how you included that in your training! 🙂 Very nice videos, great work!

  14. ann says:

    This is awesome, thank you very much!

  15. Anonymous says:

    This was great, thank you!

  16. Harini says:

    I did. 🙂

Comments are closed.