Course Code: 24375

Charts and Graphs

Class Dates:
1 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • In this course you will learn data visualization techniques you won’t find anywhere else and shows you how to use Excel to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere–even on the Web and social networks.
    Create stunning data visualizations instantly with Excel's Recommended Charts
    • Use charts to instantly reveal trends, differences, and relationships
    • Use Sparkline's to imbue worksheets with more context and insight
    • Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools
    • Build stock charts that help you make smarter investments • Solve “non-standard” problems such as noncontiguous data or custom data sequences • Generate new charts automatically with Excel VBA


Course Details

  • Introduction Using Excel to Create Charts
  • Introducing Charts in Excel
  • Choose among the three ways to create a chart
  • Creating a chart for the quick analysis icon
  • Inserting a Recommended Chart
  • Creating a Chart Using the Other Icons
  • Creating a chart using Alt+F1
  • Changing the Chart Title
  • Editing a Title in the Formula Bar
  • Charting Noncontiguous Data
  • Introducing the Three Helper Icons
  • Introducing the Format Task Pane
  • Changing the Them on the Page
  • Moving Charts
  • Customizing Charts
  • Accessing Element Formatting Tools
  • Identifying Chart Elements
  • Formatting Chart Elements
  • Formatting Individual Legend Entries
  • Adding Data Labels and Tables to a Chart
  • Formatting Axes
  • Displaying & Formatting Gridlines
  • Formatting the Plot Area & Chart Area
  • Formatting a Series and a Single Data Point
  • Replacing Data Makers with Shapes & pictures
  • Changing the Theme Colors on the Page Layout Tab
  • Storing Your favorite settings in a Chart Template
  • Creating Charts That Show Trends
  • Choosing a chart type, Column Charts
  • Line Charts, Area Charts
  • High-Low-close Charts
  • Bar Charts, Pie Charts
  • 100 Percent Stacked Bar Chart Instead of Pie Chart
  • Converting Text Dates to Dates
  • Plotting Data by Numeric Year
  • Changing Line Type Midstream
  • Adding an Automatic Trendline to a Chart
  • Understanding the Shortcomings of Stacked Column charts
  • Creating Charts That Show Differences
  • Comparing Entities
  • Using Bar Charts to Illustrate Item Comparisons
  • Adding a Second Series to show a Time Comparison
  • Subdividing a Bar to Emphasize One Component
  • Using Pie Charts
  • Switching to a 100 Percent Stacked Column chart
  • Dealing with Data Representation
  • Using a Waterfall Chart to Tell the Story of Component Decomposition
  • Creating a Stacked and Clustered Chart
  • Creating Charts That Show Relationships
  • Using Scatter Charts to Plot Pairs of Data Points
  • Creating a Scatter Chart
  • Adding Labels to a Scatter Chart in Excel
  • Adding a Second Series to a Scatter Chart
  • Drawing with a Scatter Chart
  • Adding a Third Dimension with a Bubble Chart
  • Using Charts to Show Relationships
  • Using Paired Bars to Show Relationships
  • Using a Frequency Distribution to Categorize Thousands of Points
  • Using Radar Charts to Create Performance Reviews
  • Using Surface Charts to Show Contrast
  • Using the Depth Axis
  • Creating Stock Analysis Charts
  • Overview of Stock Charts
  • Line, OHLC and Candlestick Charts
  • Obtaining Stock Data to Chart
  • Dealing with Splits Using the Adjusted Close Column
  • Creating a Line Chart
  • Adding Volume as a Column Chart to a Line Chart
  • Creating OHLC Charts
  • Creating Candlestick Charts
  • Changing Colors in a Candlestick Chart
  • Advanced Chart Techniques
  • Mixing Two Chart Types on a Single Chart
  • Moving Charts from One Worksheet to Another
  • Making Columns or Bars Float
  • Using a Rogue XY Series for Arbitrary Gridlines
  • Creating a Bullet Charts in Excel
  • Creating a Thermometer, Benchmark and Delta Chart
  • Creating Pivot Charts and Power View Dashboards
  • Creating a PivotChart Using Recommended Charts
  • Changing the Fields in the Pivot Chart
  • Sorting the Pivot Chart
  • Grouping Daily Dates in the Pivot Filter Fly out Menu
  • Filtering Pivot Charts Using Slicers
  • Connecting Multiple Pivot Charts to One Slicer
  • Using PowerPivot and Power View
  • Enabling PowerPivot and Power View
  • Loading Your Excel Data to PowerPivot
  • VLOOKUPs? Replacing, and with Relationships
  • Creating a Power View Worksheet
  • Adding a Real Slicer
  • Using Sparklines, Data Visualizations, and Other Non-Chart methods
  • Fitting a Chart into the Size of a Cell with Sparklines
  • Creating a Group of Sparklines
  • Controlling Axis Values for Sparklines
  • Setting Up Win/Loss Sparklines
  • Labeling a Sparkline
  • Using Data Bars to Create in-Cell Bar Charts
  • Showing Data Bars for a Subset of Cells
  • Customizing color Scales
  • Using Icon Sets to Segregate Data
  • Setting up an Icon Set
  • Showing an Icon for Only the Best Cell
  • Creating a Chart Using Conditional Formatting in Worksheet Cells
  • Presenting Excel Data on a Map
  • Plotting Data Geographically
  • Importing Data to MapPoint
  • Creating a Map in Power View
  • Creating a Map in GeoFlow
  • Using SmartArt diagrams and Shapes
  • Using SmartArt
  • Elements Common Across Most SmartArt
  • Inserting SmartArt
  • Adding Images, Controlling Shapes from the Text Plan, Changing Text Formatting
  • Special Considerations for Organization Charts
  • Choosing the Right Layout for Your Message
  • Exploring Business Charts That Use SmartArt Graphics
  • Illustrating a Pro/Con Decision by Using a Balance Chart
  • Illustrating Growth by Using an Upward Arrow
  • Understanding Labeled Hierarchy Charts
  • Using Other SmartArt Layouts
  • Working with Shapes
  • Exporting Charts for Using Outside of Excel
  • Presenting Excel Charts in PowerPoint or Word
  • Copying and Pasting While Keeping Original Formatting
  • Embedding the Chart and Workbook in PowerPoint
  • Copying a Chart as a Picture
  • Creating a Chart in PowerPoint with Data Pasted from Excel
  • Presenting Charts on the Web
  • Exporting Charts to Graphics using VBA
  • Converting to XPS or PDF
  • Using Excel VBA to Create Charts
  • Introduction to VBA
  • Enabling VBA in Your Copy of Excel
  • Enabling the Developer Tab
  • Visual Basic Tools
  • The Macro Recorder
  • Understanding Object-Oriented Code
  • Creating a Chart in Various Excel Versions
  • Using the .AddChart2 Method
  • Creating Charts in Excel 2007-2013
  • Creating Charts in Excel 2003-2013
  • Customizing, Specifying a Chart Title
  • Creating Advanced Charts, Pivot Charts, Exporting a Chart as a Graphic
  • Knowing When Someone is Lying to You with a Chart
  • Lying with Perspective
  • Lying with Shrinking Charts
  • Lying with Scale
  • Lying Because Excel Will Not Cooperate
  • Avoiding Stacked Surface Charts
  • Asserting a Trend from Two Data Points
  • Deliberately Using Charts to Lie
  • Charting Something Else When Numbers Are Too Bad
  • Stretching Pictographs