O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel - Charts In Detail

Video Description

In this Microsoft Excel – Charts in Detail training course, expert author Guy Vaccaro takes you beyond the basics of Excel, diving into detail about creating and using charts within this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by learning the basics of Excel charts, such as how to create them quickly and why the right chart type matters. From there, you will learn about the tools within the design and format tabs, including the different chart layout styles and colors, adding and manipulating shapes, and managing data labels. Guy will show you special chart types and properly explain scatter charts. This training video will teach you about chart data and how to create charts from multiple data sources. Finally, Guy will teach you how to print your chart and copy and link it to other Office applications. By the completion of this video based training course, you will be fully versed in creating and using Excel charts. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents

  1. Welcome
    1. A Chart Can Explain Things Better Than Numbers 00:05:52
    2. About The Author 00:01:20
    3. The Included Working Files 00:01:52
  2. Chart Basics
    1. Deciding On The Data To Be Used In A Chart 00:04:39
    2. Creating Charts Quickly 00:05:54
    3. Use Sparklines To Create Inline Charts 00:04:57
    4. Chart Areas Plot Chart Legends 00:06:59
    5. Filtering An Existing Chart 00:03:48
    6. The Right Chart Type Matters 00:04:43
    7. The Chart Sub Ribbons And Properties Box 00:05:26
  3. The Design Tab
    1. Moving Charts And Switching Rows And Columns 00:07:06
    2. Changing The Default Chart Type 00:03:09
    3. Chart Layouts Styles And Colors 00:05:59
    4. Adding And Removing Chart Elements 00:06:27
    5. Dealing With Hidden Or Empty Cells 00:05:14
    6. Dynamic Titles 00:04:14
    7. Trend Lines Used To Help Analyze Data 00:08:05
  4. The Format Tab
    1. Adding And Manipulating Shapes 00:06:39
    2. Add WordArt And Use Of WordArt Styles 00:07:06
    3. Adding Static And Dynamic Text Boxes 00:07:02
    4. Using Pictures Or Textures As Chart Element Backgrounds 00:06:13
    5. Altering Axis Formatting And Plotting 00:08:12
    6. Managing Data Labels 00:06:35
  5. Special Chart Types
    1. Multiple Chart Types In The Same Chart 00:06:07
    2. Multiple Pie Charts In The Same Sheet 00:06:22
    3. Pie Of A Pie 00:06:00
    4. Charting Stock Movements 00:07:27
    5. Radar Charts In Action 00:07:18
    6. Scatter Charts Explained 00:06:54
  6. Chart Data
    1. Changing A Charts Date Source 00:05:05
    2. Creating Charts From Multiple Data Sources 00:07:06
    3. What Happens When I Copy Sheets With Charts? 00:05:15
  7. Printing And Sharing Charts
    1. How To Print Charts 00:03:37
    2. Chart Templates 00:03:33
    3. Copying And Linking Charts To Other Office Applications 00:06:57
  8. The End
    1. Charts In Summary 00:03:57