Charts and Graphs

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