Jon's Excel Charts and Tutorials - Index

The Peltier Tech Blog

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Area Charts
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Step Charts in Microsoft Excel
  Area Chart - Invert if Negative
   
• Arrows
  Use an Arrow to Indicate Special Points
   
• Axes
  Chart Axes and Axis Tricks (overview)
  X Axis: Category or Value?
  Line Charts vs. XY Charts
  Line-XY Combination Charts
  Secondary Axes in Charts
  Secondary Axes that Work - Proportional Scales
  Tertiary Y Axis
  Vertical Category Axis (see also Dot Plots)
  Align X Axis to Y=0 on Two Y Axes (VBA)
  Link Chart Axis Scale Parameters to Values in Cells (VBA)
  Staggered Axis Labels
  Category Axis Tricks for Line and Area Charts - 1
  Category Axis Tricks for Line and Area Charts - 2
  Chart with a Dual Category Axis
  Using Pivot Table Data for a Chart with a Dual Category Axis
   
• Axes - Custom Axis Scales using Dummy Series
  Probability Chart
  Reciprocal Chart Axis Scale
  Tertiary Y Axis
  Vertical Category Axis
  Scientific/Exponential Notation Axis Labels
   
• Background Effects
  Shaded Quadrant Background for Excel XY Scatter Chart
  Colored Vertical Band
  Excel Chart With Horizontal Bands
  Highlight Certain Time Periods in a Chart
  Fill Effects
   
• Binding (VBA)
  Early vs. Late Binding
   
• Books
  A list of books that I own and use while developing in Excel
   
• Bubble Charts
  Bubble Charts in Microsoft Excel
  Control Bubble Chart Bubble Sizes
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Cell Charts
  In Cell Charting with Worksheet Formulas
   
• Chart Types
  Chart Types
  Chart Types Excel Doesn't Have
  Line Charts vs. XY Charts
  Stock Charts and Other Line Chart Tricks
  Column Charts in Microsoft Excel
  Surface and Contour Charts in Microsoft Excel
  Bubble Charts in Microsoft Excel
  Roll Your Own Combination Chart
  Creating a User Defined Chart Type
   
• Chart Types - Custom
  Chart Types Excel Doesn't Have
  Creating a Custom (User Defined) Chart Type
  Shaded Quadrant Background for Excel XY Scatter Chart
  Colored Vertical Band
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Excel Waterfall Charts (Bridge Charts)
  Stock Charts
  Box and Whisker Diagrams (Box Plots)
  Probability Chart
  Histograms
  Variable Width Column Charts
  Step Charts in Microsoft Excel
   
• Column Charts
  Add a Line to a Column or Line Chart.
  Dynamic Column Chart
  Histograms
  Stacked Column Charts that Cross the X Axis
  Box and Whisker Diagram (Box Plots)
  Excel Waterfall Charts (Bridge Charts)
  Column Chart with Horizontal Line Segments
  Variable Width Column Charts
   
• Combination Charts
  Combination Charts (overview)
  Roll Your Own Combination Chart
  Bar-Line Combination Chart
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Combination Clustered Columns with Clustered Lines
  Column Chart with Horizontal Line Segments
  Speedometer Chart
  Gantt Charts in Microsoft Excel
  Dot Plots
  Line-XY Combination Charts
   
• Conditional Charts
  Conditional Formatting of Excel Charts
  Special Format for Minimum and Maximum
  Use an Arrow to Indicate Special Points
  VBA Conditional Formatting of Charts by Series Name
  VBA Conditional Formatting of Charts by Value
  VBA Conditional Formatting of Charts by Category Label
   
• Control Charts (Statistical Process Control: Run Charts)
  Run Chart with Mean and Standard Deviation Lines
   
• Controls for Charts
  Chart by Combo Box or Checkbox
  Interactive Parallel Coordinates Chart
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Dashboards
  Effective Dashboards
  Dashboards
  Arranging Charts in a Grid
  Creating Charts in a Grid
   
• Data
  Consolidate Text Data for Charting
  Source Data
  The Chart and its Data Range
  Charting Data From Different Sheets
  Delinking Chart Data
  The Chart Series Formula
   
• Data Labels
  Exponential Notation Axis Labels
  Label Last Point
  Label Last Point for Excel 2007
  Label Last Point - Updated Add-In
  Label Each Series in a Chart
   
• Dial Chart
  Speedometer Chart
   
• Dot Plots
  Dot Plots
  Tornado Charts and Dot Plots
   
• Drop Lines
  Drop Lines in Excel Charts
   
• Dummy Series
  Dummy Series (overview)
  Axes - Custom Axis Scales using Dummy Series
  Double Legend in a Single Chart
   
• Dynamic Charts
  Dynamic and Interactive Charts (overview)
  Dynamic Charts
  Dynamic Column Chart
  Another Dynamic Chart
  Chart the Last 12 Months
  Charting Dynamic Normalized Ranges
  Dynamic Chart using Pivot Table and Range Names
  Dynamic Chart using Pivot Table and VBA
  Dynamic Ranges to Find and Plot Desired Columns
  Split Data Range into Multiple Chart Series without VBA
  VBA to Split Data Range into Multiple Chart Series
  Dynamic Chart Source Data (VBA)
  Dynamic Chart with Multiple Series
   
• Early Binding (VBA)
  Early vs. Late Binding
   
• Error Bars
  Error Bars in Excel Charts
  Error Bars in Excel 2007 Charts
  Custom Error Bars in Excel Charts
   
• Error Bars Used in Special Effects
  Add a Horizontal Line to a Column or Line Chart: Error Bar Method.
  Add a Vertical Line to a Column or Line Chart: Error Bar Method.
  Box and Whisker Diagram (Box Plots)
  Column Chart with Horizontal Line Segments
  Step Charts in Microsoft Excel
  Stock Charts and Other Line Chart Tricks
   
• Errors in Excel
  Pie Chart Rounding in Excel
  Error Free VBA
  Excel 2007 Regression Error - Fixed in SP1
   
• Equations
  Plot an Equation
   
• Excel 2007
  A Belated Review of Excel 2007
  Changes to Charting in Excel 2007
  Why I don't like Excel 2007 charts
  What happened to my favorite Excel 2003 Chart feature?
  Poor Charting Performance in Excel 2007
  Excel 2007 Chart Performance - Revisited
  Excel 2007 Recalculates Slowly
  Excel 2007 Regression Error - Fixed in SP1
  Error Bars in Excel 2007
  Installing an Add-In in Excel 2007
   
• Exponential Notation
  Exponential Notation Axis Labels
   
• Fill Effects
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Line and Fill Effects in Excel Charts Using VBA
  Excel Chart With Horizontal Bands
  Background Effects
   
• Formatting
  Using Colors in Excel Charts
  Conditional Formatting of Excel Charts
  VBA Conditional Formatting of Charts by Series Name
  VBA Conditional Formatting of Charts by Value
  VBA Conditional Formatting of Charts by Category Label
  Special Format for Minimum and Maximum
  Variable Width Column Charts
  Number Formats in Excel
  Control Bubble Chart Bubble Sizes
  Line and Fill Effects in Excel Charts Using VBA
  Connect Two XY Series
  Connect Two XY Series with Arrows (VBA)
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Invert if Negative
  Area Chart - Invert if Negative
   
• Forms (VBA)
  Property Procedures - Passing Information to and from Forms
   
• Formula
  The Chart Series Formula
  Change Series Formulas (VBA)
   
• Formula Charts
  In Cell Charting with Worksheet Formulas
   
• Formula, Plotting
  Plot an Equation
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Gauge Chart
  Speedometer Chart
   
• Gridlines
  Make Gridlines Square
   
• Histograms
  Histograms
  Custom Histograms
   
• Horizontal Lines - Add Lines to a Chart
  Add a Line to a Column or Line Chart.
  - Add a Horizontal Line to a Column or Line Chart: Series Method.
  - Add a Horizontal Line to a Column or Line Chart: Error Bar Method.
  Run Chart with Mean and Standard Deviation Lines
   
• Hyperlinks
  Hyperlinks
   
• In-Cell Charts
  In Cell Charting with Worksheet Formulas
   
• Interactive Charts
  Dynamic and Interactive Charts (overview)
  Interactive Charting by Combo Box or Checkbox
  Interactive Parallel Coordinates Chart
  Interactive Chart Creation (VBA)
   
• Labels
  Exponential Notation Axis Labels
  Label Last Point (VBA)
  Label Each Series in a Chart
   
• Late Binding (VBA)
  Early vs. Late Binding
   
• Layered Charts
  Stacked Charts With Vertical Separation
   
• Line Charts
  Line Charts vs. XY Charts
  X Axis: Category or Value?
  Stock Charts and Other Line Chart Tricks
  Drop Lines in Excel Charts
  Step Charts in Microsoft Excel
  Interactive Parallel Coordinates Chart
  Line-XY Combination Charts
   
• Lines - Add Lines to a Chart
  Add a Line to a Column or Line Chart.
  - Add a Horizontal Line to a Column or Line Chart: Series Method.
  - Add a Horizontal Line to a Column or Line Chart: Error Bar Method.
  - Add a Vertical Line to a Column or Line Chart: Series Method.
  - Add a Vertical Line to a Column or Line Chart: Error Bar Method.
  Run Chart with Mean and Standard Deviation Lines
  Use an Arrow to Indicate Special Points
   
• Links (hyperlinks)
  Hyperlinks
   
• Links (in the chart)
  Delinking Chart Data
  Link Chart Axis Scale Parameters to Values in Cells
  Link Chart Text to a Cell
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Markers
  Use an Arrow to Indicate Special Points
   
• Microsoft Office
  Using Excel with Other Office Applications
   
• Name
  Chart Names
   
• Normalized Data
  Charting Dynamic Normalized Ranges
   
• Number Formats
  Number Formats in Excel
  Exponential Notation Axis Labels
   
• Office
  Using Excel with Other Office Applications
   
• Panel Charts
  Panel Chart Example: Chart with Vertical Panels
  Stacked Charts With Vertical Separation
  Panel Charts with Different Scales
   
• Parallel Coordinates Charts
  Interactive Parallel Coordinates Chart
   
• PowerPoint
  Using Excel with Other Office Applications
   
• Probability Chart
  Probability Chart
   
• Profile Plots
  Interactive Parallel Coordinates Chart
   
• Property Procedures (VBA)
  Property Procedures - Passing Information to and from Forms
   
• Protection
  Protecting Charts
   
• Run Charts (Statistical Process Control: Control Charts)
  Statistical Process Control
  Introducing Control Charts (Run Charts)
  Run Chart with Mean and Standard Deviation Lines
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Scientific Notation
  Exponential Notation Axis Labels
   
• Series Formula
  The Chart Series Formula
  Change Series Formulas (VBA)
   
• Shapes in Charts
  Line and Fill Effects in Excel Charts Using VBA
  Use an Arrow to Indicate Special Points
  Connect Two XY Series with Arrows (VBA)
   
• SOLVER
  Using SOLVER in VBA
   
• Speedometer Chart
  Speedometer Chart
   
• Square Gridlines
  Make Gridlines Square
   
• Stacked Charts
  Stacked Line Chart
  Stacked Charts With Vertical Separation
  Stacked Column Charts that Cross the X Axis
  Box and Whisker Diagram (Box Plots)
   
• Statistical Charts
  Box and Whisker Diagram (Box Plots)
  Probability Chart
  Statistical Process Control
  Introducing Control Charts (Run Charts)
  Run Chart with Mean and Standard Deviation Lines
  Moving Averages
  Histograms
  Custom Histograms
  Interactive Parallel Coordinates Chart
  Statistics: Main Effects Plot
   
• Step Charts
  Step Charts in Microsoft Excel
  Line Chart vs. Step Chart
  Step Chart Without Risers
   
• Stock Charts
  Stock Charts and Other Line Chart Tricks
  Stock Chart with Added Series
  Stock Chart with Left Tick Marker for Open Series
  - Stock Charts and Other Line Chart Tricks
  Candlestick Alternative: Individually Colored Up-Down Bars
  Charting Dynamic Normalized Ranges
  Stock Charts in Excel 2007
   
• Types
  Chart Types
  Chart Types Excel Doesn't Have
  Line Charts vs. XY Charts
  Roll Your Own Combination Chart
  Surface and Contour Charts in Microsoft Excel
  Creating a Custom Chart Type
   
• Types - Custom Chart Types
  Shaded Quadrant Background for Excel XY Scatter Chart
  Colored Vertical Band
  Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart)
  Excel Waterfall Charts (Bridge Charts)
  Stock Chart with Added Series
  Box and Whisker Diagram (Box Plots)
  Probability Chart
  Histograms
  Custom Histograms
  Variable Width Column Charts
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• UserForms (VBA)
  Property Procedures - Passing Information to and from Forms
   
• VBA
  VBA Macros
  - How To: Use Someone Else’s Macro
  - How To: Record Your Own Macro
  - How To: Fix a Recorded Macro
  - Make Your Recorded Macro Independent of Which Sheet is Active
  - How To: Assign a Macro to a Toolbar or Menu
  - How To: Assign a Macro to an ActiveX Control
  - How To: Assign a Macro to a Button or Shape
  - Installing an Excel Add-In
  - Installing an Add-In in Excel 2007
  
  General VBA
  - Error Free VBA
  - Using Excel with Other Office Applications
  - Early vs. Late Binding
  - Hyperlinks
  - Property Procedures - Passing Information to and from Forms
  - File Name Functions
  - Save and Retrieve Information With Text Files
  - Using SOLVER in VBA
  - VB Editor Settings
  - Installing an Excel Add-In
  - Get Open or Save-As Filename
  
  VBA Charting Techniques and Examples
  - VBA Charting Techniques (overview)
  - Quick Chart VBA Examples
  - Excel XY Chart Variations with VBA
  - Resizing and Moving Charts in VBA
  - Change Series Formulas
  - Delinking Chart Data
  - Interactive Chart Creation
  - Link Chart Axis Scale Parameters to Values in Cells
  - Align X Axis to Y=0 on Two Y Axes
  - Exponential Notation Axis Labels
  - Square Gridlines
  - Label Last Point
  - Label Each Series in a Chart
  - VBA Conditional Formatting of Charts by Series Name
  - VBA Conditional Formatting of Charts by Value
  - VBA Conditional Formatting of Charts by Category Label
  - Line and Fill Effects in Excel Charts Using VBA
  - Connect Two XY Series with Arrows (VBA)
  - Bubble Charts in Microsoft Excel
  - Chart Events in Microsoft Excel
  - Arranging Charts in a Grid
  - Creating Charts in a Grid
  - Pivot Table Programming
  - Export Chart as Image File
  - Enhanced Export Chart Procedure
  - Dynamic Chart Source Data (VBA)
   
• Vertical Lines - Add Lines to a Chart
  Add a Line to a Column or Line Chart.
  - Add a Vertical Line to a Column or Line Chart: Series Method.
  - Add a Vertical Line to a Column or Line Chart: Error Bar Method.
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

• Waterfall Chart
  Excel Waterfall Charts (Bridge Charts)
   
• Wizard
  Chart Wizard
   
• Word
  Using Excel with Other Office Applications
   
• Worksheet Charts
  In Cell Charting with Worksheet Formulas
   
• Worksheet Controls for Charts
  Chart by Combo Box or Checkbox
   
• X-Y Charts
  Line-XY Combination Charts
   

| # | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Top of Page |

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | PTS Blog

Peltier Technical Services, Inc., Copyright © 2023. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile