Jon's Excel Charts and Tutorials - Index

| # | 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 |

• Gantt Charts
  Gantt Charts in Microsoft Excel (TechTrax Article)
  Advanced Gantt Charts in Microsoft Excel
  Gantt Chart Links
   
• Gauge Chart
  Speedometer Chart
   
• Gridlines
  Arbitrary Gridlines
  Arbitrary Gridlines, Take Two (zip file)
  Arbitrary Gridlines and Axis Labels
  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)
  Select a Chart Type with List Box or Drop Down Control
  Interactive Charting by Combo Box or Checkbox
  Interactive Parallel Coordinates Chart
  Interactive Chart Creation (VBA)
  Dynamic Charting By Dates (TechTrax Article)
   
• Labels
  Exponential Notation Axis Labels
  Add Labels to Points that are Off Scale
  Label Last Point (VBA)
  Label Each Series in a Chart (PTS Blog)
   
• Late Binding (VBA)
  Early vs. Late Binding
   
• Layered Charts
  Stacked Charts With Vertical Separation
   
• Legends
  Legends in Excel Charts - Formats, Size, Shape, and Position (PTS Blog)
  Legend Entry Tricks in Excel Charts (PTS Blog)
  Order of Legend Entries in Excel Charts (PTS Blog)
  Double Legend in a Single Chart (PTS Blog)
   
• Line Charts
  Scatter Chart or Line Chart? (TechTrax Article)
  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 (PTS Blog)
   
• 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 (PTS Blog)
   
• Links (to other resources)
  LINKS
  Links to Excel Resources
  - Web Sites
  - Forums
  - Blogs
  Links to Pivot Table Resources
  Links to Charting Resources
  - Dynamic Chart Links
  - Gantt Chart Links
  Links to VBA Resources
  Links to Statistics Resources
  Books that I own and use while developing in Excel
   

| # | 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 |

• Marimekko Chart
  Marimekko Charts (PTS Blog)
  Marimekko Chart Utility (PTS Blog)
  The Problem with Marimekkos (PTS Blog)
  Marimekko Replacement - Overlapping Bars (Easy) (PTS Blog)
  Marimekko Replacement - Overlapping Bars (Hard) (PTS Blog)
  Marimekko Replacement - 2 by 2 Panel (PTS Blog)
  Matrix Chart (TechTrax Article)
   
• Markers
  Custom Markers
  Use an Arrow to Indicate Special Points
   
• Menus
  Excel Menus and Command Bars
  Custom Drawing Command Bars
   
• Microsoft Office
  Using Excel with Other Office Applications
  Custom Drawing Command Bars
   
• Mosaic Charts
  See Marimekko Charts
   
• Name
  Chart Names
   
• Normalized Data
  Charting Dynamic Normalized Ranges
   
• Number Formats
  Number Formats in Excel (also appears in TechTrax Ezine)
  Exponential Notation Axis Labels
   
• Office
  Using Excel with Other Office Applications
  Custom Drawing Command Bars
   
• Panel Charts
  Panel Chart Example: Chart with Vertical Panels
  Stacked Charts With Vertical Separation
  Births by Day of the Year
  Panel Charts with Different Scales
   
• Parallel Coordinates Charts
  Interactive Parallel Coordinates Chart
   
• Pictograms
  Build a Column or Bar Chart with Images
   
• Pie Charts
  Pie Chart Rounding in Excel (PTS Blog)
  Pie Charts in Microsoft Excel (TechTrax Article)
  Pie of Pie Charts and other Pie Chart Tricks (TechTrax Article)
   
• Pivot Tables and Pivot Charts
  Contributed by fellow Excel MVP Debra Dalgleish. Check out Debra's Excel Tips page
  - Introduction to Pivot Tables in Excel
  - Working with Pivot Charts in Excel
  - Pivot Table Programming
  - Pivot Table and Pivot Chart Links
  Pivot Tables, Pivot Charts, and Real Charts (TechTrax Article)
  Grouping by Date in a Pivot Table (PTS Blog)
  Using Pivot Table Data for a Chart with a Dual Category Axis (PTS Blog)
  Dynamic Chart using Pivot Table and Range Names (PTS Blog)
  Dynamic Chart using Pivot Table and VBA (PTS Blog)
  Regular Charts from Pivot Tables (PTS Blog)
   
• PowerPoint
  Using Excel with Other Office Applications
  Custom Drawing Command Bars
   
• Probability Chart
  Probability Chart
   
• Profile Plots
  Interactive Parallel Coordinates Chart
   
• Property Procedures (VBA)
  Property Procedures - Passing Information to and from Forms
   
• Protection
  Protecting Charts
   
• Radar Charts
  Line and Fill Effects in Excel Radar Charts Using VBA
   
• Run Charts (Statistical Process Control: Control Charts)
  Statistical Process Control (PTS Blog)
  Introducing Control Charts (Run Charts) (PTS Blog)
  Run Chart with Mean and Standard Deviation Lines
  Dynamic Control Chart (zip file only)
  Woody Santy's Control Chart (zip file only, provided by Woody Santy)
   

| # | 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
   
• Scripts
  VBA
  VBScript
   
• Search this site
   
• Series Formula
  The Chart Series Formula
  Change Series Formulas (VBA)
   
• Shapes in Charts
  Custom Series Formatting
  Line and Fill Effects in Excel Charts Using VBA
  Use an Arrow to Indicate Special Points
  Connect Two XY Series with Arrows (VBA) (PTS Blog)
   
• 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
  Horizontal Box and Whisker Plots
  Vertical Box and Whisker Plots
  Clustered-Stacked Column Chart
  Charting Passenger Volume with a Stacked Area Chart (TechTrax Article)
  Gantt Charts (stacked bar charts)
   
• Stacked-Clustered Column Charts
  PTS Cluster Stack Chart Utility and Documentation
  Clustered-Stacked Column Charts (PTS Blog)
  Clustered-Stacked Column Chart
   
• Statistical Charts
  Box and Whisker Charts
  Probability Chart
  Statistical Process Control (PTS Blog)
  Introducing Control Charts (Run Charts) (PTS Blog)
  Run Chart with Mean and Standard Deviation Lines
  Dynamic Control Chart (zip file only)
  Woody Santy's Control Chart (zip file only, provided by Woody Santy)
  Moving Averages (PTS Blog)
  Histograms
  Custom Histograms
  Creating Paired Comparison Charts in Microsoft Excel (TechTrax Article)
  Interactive Parallel Coordinates Chart
  Statistics: Main Effects Plot (PTS Blog)
  Links to Statistics Resources
   
• Step Charts
  Step Charts in Microsoft Excel
  Line Chart vs. Step Chart (PTS Blog)
  Step Chart Without Risers (PTS Blog)
   
• Stock Charts
  Stock Charts and Other Line Chart Tricks
  Horizontal Stock Chart
  Stock Chart with Added Series
  Stock Chart with Left Tick Marker for Open Series
  - New way: Stock Charts and Other Line Chart Tricks
  - Old way: Stock Chart with Left Tick Marker for Open Series
  Candlestick Alternative: Individually Colored Up-Down Bars (PTS Blog)
  Charting Dynamic Normalized Ranges
  Stock Charts in Excel 2007
   
• Surface Charts
  Surface and Contour Charts in Microsoft Excel (TechTrax Article)
   
• Symbols
  ASCII Table
   
• Tech Trax (my articles in the e-zine)
  TechTrax Ezine
  Scatter Chart or Line Chart?
  Microsoft Excel Charting FAQs
  Dynamic Charting By Dates
  Microsoft Excel Chart Types
  Gantt Charts in Microsoft Excel
  Pie Charts in Microsoft Excel
  Number Formats in Excel (also appears on this web site)
  Surface and Contour Charts in Microsoft Excel
  Pie of Pie Charts and other Pie Chart Tricks
  Matrix Chart
  Charting Passenger Volume with a Stacked Area Chart
  Pivot Tables, Pivot Charts, and Real Charts
  Apply Fill Color Between Lines in a Chart
  Using Text Files to Save and Retrieve Information in Microsoft Excel
  Creating Paired Comparison Charts in Microsoft Excel
   
• Text Files
  Using Text Files to Save and Retrieve Information in Microsoft Excel (TechTrax Article)
   
• Tool Bars
  Excel Menus and Command Bars
  Custom Drawing Command Bars
   
• Tornado Charts
  Tornado Charts and Dot Plots (PTS Blog)
  Tornado Charts
   
• Tutorial
  Charting Tutorial (overview)
   
• Types
  Chart Types
  Chart Types Excel Doesn't Have
  Microsoft Excel Chart Types (TechTrax Article)
  Scatter Chart or Line Chart? (TechTrax Article)
  Roll Your Own Combination Chart
  Pie Charts in Microsoft Excel (TechTrax Article)
  Pie of Pie Charts and other Pie Chart Tricks (TechTrax Article)
  Surface and Contour Charts in Microsoft Excel (TechTrax Article)
  Creating a Custom Chart Type
   
• Types - Custom Chart Types
  Chart with Colored Quadrant Background
  Colored Vertical Band
  Tornado Charts
  Columns on Two Axes
  XY Area Chart: Fill Below an XY Series
  - XY Area Chart: Fill Below an XY Series (Excel 2003 and earlier)
  - Fill Below an XY Chart Series (Excel 2003 and 2007)
  XY Area Chart: Fill Between XY Series
  - XY Area Chart: Fill Between XY Series (Excel 2003 and earlier)
  - Fill Between XY Chart Series (Excel 2003 and 2007)
  Brickyard Chart
  Waterfall Charts (and Utility)
  Horizontal Stock Chart
  Stock Chart with Added Series
  Stock Chart with Left Tick Marker for Open Series
  Horizontal Box and Whisker Plots
  Vertical Box and Whisker Plots
  Probability Chart
  Dynamic Control Chart (zip file)
  Histograms
  Custom Histograms
  Column Chart with Variable Width Columns
  Variable Width Column Charts
  Clustered-Stacked Column Chart
  Gantt Charts
  Creating Paired Comparison Charts in Microsoft Excel (TechTrax Article)
   

| # | 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
   
• Utilities
  Indispensable Excel Utilities (PTS Blog)
  
  Professional PTS Utilities
  - PTS Waterfall Chart Utility and Documentation
  - PTS Box and Whisker Plot Utility and Documentation
  - PTS Cluster Stack Chart Utility and Documentation
  - PTS Marimekko Chart Utility and Documentation
  - PTS Dot Plot Utility and Documentation
  
  Self-contained add-in utilities
  See Installing an Excel Add-In and Installing an Add-In in Excel 2007 (PTS Blog)
  - Quick Chart Utility
  - Change Series Formula utility in How to Edit Series Formulas (PTS Blog)
  - Enhanced Export Chart Procedure (PTS Blog)
  - LOESS Utility for Excel (PTS Blog)
  - Error Bars in Excel 2007 (PTS Blog)
  - Palette Chooser in Excel Chart Color Update (PTS Blog)
  
  Other useful tools
  - Align Chart Dimensions (zip file)
  - Switch X and Y (zip file)
  - Change Series Formulas
  - Chart Size on your Menu (XL 2000+ zip file)
  - Chart Size on your Menu (XL 97 zip file)
  - Convert Fahrenheit to Celcius (Zipped Excel File)
  - List and Print Excel Files (Zipped Excel File)
  - ASCII Table
   
• VBA
  VBA Macros
  - How To: Use Someone Else’s Macro (PTS Blog)
  - How To: Record Your Own Macro (PTS Blog)
  - How To: Fix a Recorded Macro (PTS Blog)
  - Make Your Recorded Macro Independent of Which Sheet is Active (PTS Blog)
  - How To: Assign a Macro to a Toolbar or Menu (PTS Blog)
  - How To: Assign a Macro to an ActiveX Control (PTS Blog)
  - How To: Assign a Macro to a Button or Shape (PTS Blog)
  - Installing an Excel Add-In (PTS Blog)
  - Installing an Add-In in Excel 2007 (PTS Blog)
  
  General VBA
  - Error Free VBA
  - Using Excel with Other Office Applications
  - Custom Drawing Command Bars
  - Early vs. Late Binding
  - Hyperlinks
  - Property Procedures - Passing Information to and from Forms
  - File Name Functions (PTS Blog)
  - Using Text Files to Save and Retrieve Information in Microsoft Excel (TechTrax Article)
  - Using SOLVER in VBA
  - VB Editor Settings (PTS Blog)
  - Installing an Excel Add-In (PTS Blog)
  - File Name Functions (PTS Blog)
  - Get Open or Save-As Filename (PTS Blog)
  
  VBA Charting Techniques and Examples
  - VBA Charting Techniques (overview)
  - Quick Chart VBA Examples
  - Excel XY Chart Variations with VBA
  - Quick XY Chart Utility
  - Resizing and Moving Charts in VBA
  - Align (Overlay) Charts
  - 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 (PTS Blog)
  - VBA Conditional Formatting of Charts by Series Name (PTS Blog)
  - VBA Conditional Formatting of Charts by Value (PTS Blog)
  - VBA Conditional Formatting of Charts by Category Label (PTS Blog)
  - Line and Fill Effects in Excel Charts Using VBA
  - Line and Fill Effects in Excel Radar Charts Using VBA
  - Connect Two XY Series with Arrows (VBA) (PTS Blog)
  - Dynamic Control Chart (zip file)
  - Get Information about a Point on a Chart Sheet (zip file)
  - Get Information about a Point in an Embedded Chart (zip file)
  - Pie Charts in Microsoft Excel (TechTrax Article)
  - Bubble Charts in Microsoft Excel
  - Chart Events in Microsoft Excel (Computor Companion article)
  - Arranging Charts in a Grid (PTS Blog)
  - Creating Charts in a Grid (PTS Blog)
  - Pivot Table Programming
  - Export Chart as Image File (PTS Blog)
  - Enhanced Export Chart Procedure (PTS Blog)
  - Dynamic Chart Source Data (VBA) (PTS Blog)
   
• VBScript
  VBScript
   
• 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
  Waterfall Charts
  Fancy Waterfall Chart
  Waterfall Charts that Cross the X Axis
  PTS Waterfall Chart Utility and Documentation
   
• Wizard
  Chart Wizard
   
• Word
  Using Excel with Other Office Applications
   
• Worksheet Charts
  In Cell Charting with Worksheet Formulas
   
• Worksheet Controls for Charts
  Select a Chart Type with List Box or Drop Down Control
  Chart by Combo Box or Checkbox
  Dynamic Charting By Dates (TechTrax Article)
   
• X-Y Charts
  Line-XY Combination Charts (PTS 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 |