Excel Dashboards

Books at Amazon.com

• Peltier Tech Blog
  The Peltier Tech Weblog
   

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

• 3-D Charts
  The Perils of Being in 3D
  Surface and Contour Charts in Microsoft Excel (TechTrax Article)
   
• Add-Ins
  Installing an Excel Add-In
  Installing an Add-In in Excel 2007
   
• Area Charts
  Fill Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (XY-Area Combo Chart)
  Step Charts in Microsoft Excel
  Apply Fill Color Between Lines in a Chart (TechTrax Article)
  Matrix Chart (TechTrax Article)
  Area Combination Chart for Monthly Temperatures
  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?
  Scatter Chart or Line Chart? (TechTrax Article)
  Line-XY Combination Charts
  Secondary Axes in Charts
  Secondary Axes that Work - Proportional Scales
  Arbitrary Axis Scale
  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)
  Switch X and Y (VBA: zip file)
  Staggered Axis Labels
  Create Multiple Combination Charts in Excel (Computor Companion article)
  Axis Label Cut Off
  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
  Arbitrary Axis Scale
  Arbitrary Gridlines
  Arbitrary Gridlines and Axis Labels
  Probability Chart
  Reciprocal Axis Chart
  Tertiary Y Axis
  Vertical Category Axis
  Scientific/Exponential Notation Axis Labels
   
• Background Effects
  Chart with Colored Quadrant Background
  Matrix Chart (Variable Width Stacked Columns) (TechTrax Article)
  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
   
• Box and Whisker Plots
  Box and Whisker Diagram (Box Plots)
  Peltier Tech Box and Whisker Plot Utility and Documentation
   
• Bridge Chart (Waterfall Chart)
  Excel Waterfall Charts (Bridge Charts)
   
• 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
   
• Characters
  ASCII Table
   
• Chart Events
  Get Information about a Point on a Chart Sheet (zip file)
  Get Information about a Point in an Embedded Chart (zip file)
  Chart Events in Microsoft Excel (Computor Companion article)
   
• Chart Types
  Chart Types
  Microsoft Excel Chart Types (TechTrax Article)
  Chart Types Excel Doesn't Have
  Scatter Chart or Line Chart? (TechTrax Article)
  Stock Charts and Other Line Chart Tricks
  Column Charts in Microsoft Excel
  Pie Charts in Microsoft Excel
  Surface and Contour Charts in Microsoft Excel (TechTrax Article)
  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
  Chart with Colored Quadrant Background
  Colored Vertical Band
  Fill Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (XY-Area Combo Chart)
  Brickyard Chart
  Excel Waterfall Charts (Bridge Charts)
  Stock Charts
  Box and Whisker Diagrams (Box Plots)
  Probability Chart
  Dynamic Control Chart (zip file)
  Histograms
  Variable Width Column Charts
  Clustered and Stacked Column and Bar Charts
  Gantt Charts
  Combination Chart for Monthly Temperatures
  Charting Passenger Volume with a Stacked Area Chart (TechTrax Article)
  Creating Paired Comparison Charts in Microsoft Excel (TechTrax Article)
  Step Charts in Microsoft Excel
   
• Chart Wizard
  Chart Wizard
   
• Clustered-Stacked Column Charts
  Clustered and Stacked Column and Bar Charts
  Peltier Tech Cluster Stack Chart Utility and Documentation
   
• Colors
  Using Colors in Excel Charts
  Excel Chart Color Update
   
• Column Charts
  Add a Line to a Column or Line Chart.
  Dynamic Column Chart
  Histograms
  Stacked Column Charts that Cross the X Axis
  Floating Column Charts
  Box and Whisker Diagram (Box Plots)
  Excel Waterfall Charts (Bridge Charts)
  Clustered and Stacked Column and Bar Charts
  Column Chart with Horizontal Line Segments
  Variable Width Column Charts
  Matrix Chart (Variable Width Stacked Columns) (TechTrax Article)
  Column Combination Chart for Monthly Temperatures (all positive temperatures)
  Column Combination Chart for Monthly Temperatures (positive and negative temperatures)
  Deviation Column Charts
   
• Combination Charts
  Combination Charts (overview)
  Roll Your Own Combination Chart
  Bar-Line Combination Chart
  Fill Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (XY-Area Combo Chart)
  Combination Clustered Columns with Clustered Lines
  Column Chart with Horizontal Line Segments
  Clustered and Stacked Column and Bar Charts
  Speedometer Chart
  Gantt Charts in Microsoft Excel - Advanced Techniques
  Create Multiple Combination Charts in Excel (Computor Companion article)
  Column Combination Chart for Monthly Temperatures (all positive temperatures)
  Column Combination Chart for Monthly Temperatures (positive and negative temperatures)
  Area Combination Chart for Monthly Temperatures
  Dot Plots
  Line-XY Combination Charts
   
• Computor Companion (my articles in the e-zine)
  Computor Companion Ezine "The Practical Guide to Using Computers Effectively"
  Create Multiple Combination Charts in Excel
  Chart Events in Microsoft Excel
   
• 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
   
• Contour Charts
  Surface and Contour Charts in Microsoft Excel (TechTrax Article)
   
• Control Charts (Statistical Process Control: Run Charts)
  Run Chart with Mean and Standard Deviation Lines
  Dynamic Control Chart (zip file only)
   
• 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)
  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
  Get Information about a Point on a Chart Sheet (zip file)
  Get Information about a Point in an Embedded Chart (zip file)
   
• Data Labels
  Exponential Notation Axis Labels
  Add Labels to Points that are Off Scale
  Label Last Point
  Label Each Series in a Chart
   
• Dial Chart
  Speedometer Chart
   
• Dot Plots
  Dot Plots
  Tornado Charts and Dot Plots
  Peltier Tech Dot Plot Utility and Documentation
   
• Drop Lines
  Drop Lines in Excel Charts
   
• Dummy Series
  Dummy Series (overview)
  Axes - Custom Axis Scales using Dummy Series
  Floating Column Charts
  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
  Dynamic Charting By Dates (TechTrax Article)
  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
  Dynamic Chart Links
   
• Early Binding (VBA)
  Early vs. Late Binding
   
• Error Bars
  Error Bars in Excel Charts
  Error Bars in Excel 2007
   
• 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.
  Arbitrary Gridlines
  Box and Whisker Diagram (Box Plots)
  Horizontal Stock Chart
  Column Chart with Horizontal Line Segments
  Step Charts in Microsoft Excel
  Stock Charts and Other Line Chart Tricks
   
• Errors in Excel
  Error: "No more new fonts may be applied in this workbook"
  "Not Enough Memory" Error When You Add Chart to Workbook
  Error Copying Worksheets Containing Charts
  Pie Chart Rounding in Excel
  Error Free VBA
  Excel 2007 Regression Error - Fixed in SP1
   
• Equations
  Plot an Equation
   
• Events
  Get Information about a Point on a Chart Sheet (zip file)
  Get Information about a Point in an Embedded Chart (zip file)
  Chart Events in Microsoft Excel (Computor Companion article)
   
• 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
   
• Export Charts
  Export Chart as Image File
  Enhanced Export Chart Procedure
  Image File Type Comparison of Exported Charts
   
• FAQs
  Microsoft Excel Charting FAQs (TechTrax Article)
   
• Fill Effects
  Fill Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (XY-Area Combo Chart)
  Line and Fill Effects in Excel Charts Using VBA
  Excel Chart With Horizontal Bands
  Background Effects
   
• Floating Bar Charts
  Box and Whisker Diagram (Box Plots)
  Gantt Charts in Microsoft Excel - Advanced Techniques
  Gantt Charts in Microsoft Excel (TechTrax Article)
  See also Floating Column Charts
   
• Floating Column Charts
  Floating Column Charts
  Box and Whisker Diagram (Box Plots)
  Excel Waterfall Charts (Bridge Charts)
   
• Fonts
  Fix Chart Font Scaling
  Error: "No more new fonts may be applied in this workbook"
  "Not Enough Memory" Error When You Add Chart to Workbook
  Error Copying Worksheets Containing Charts
   
• 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
  Clustered and Stacked Column and Bar 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 Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (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
   
• Frequently Asked Questions
  Microsoft Excel Charting FAQs (TechTrax Article)
   
• Funnel Charts
  Tornado Charts and Dot Plots
  Bad Graphics - Funnel 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 |

• 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
   
• Late Binding (VBA)
  Early vs. Late Binding
   
• Layered Charts
  Stacked Charts With Vertical Separation
   
• Legends
  Legends in Excel Charts - Formats, Size, Shape, and Position
  Legend Entry Tricks in Excel Charts
  Order of Legend Entries in Excel Charts
  Double Legend in a Single Chart
   
• 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
   
• 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
   
• 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
  Marimekko Chart Utility
  The Problem with Marimekkos
  Marimekko Replacement - Overlapping Bars (Easy)
  Marimekko Replacement - Overlapping Bars (Hard)
  Marimekko Replacement - 2 by 2 Panel
  Matrix Chart (TechTrax Article)
   
• Markers
  Use an Arrow to Indicate Special Points
   
• Microsoft Office
  Using Excel with Other Office Applications
   
• 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
   
• 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
   
• Pie Charts
  Pie Chart Rounding in Excel
  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)
  Pivot Table Articles on the Peltier Tech Blog
  - Explore Your Data With Pivot Tables
  - Preliminary Data Exploration with Excel Pivot Tables
  - Making Regular Charts from Pivot Tables
  - Update Regular Chart when Pivot Table Updates
  - Using Pivot Table Data for a Chart with a Dual Category Axis
  - Grouping by Date in a Pivot Table
  - Referencing Pivot Table Ranges in VBA
  - Copy a Pivot Table and Pivot Chart and Link to New Data
  - Pivot Table Conditional Formatting with VBA
  - Dynamic Chart using Pivot Table and Range Names
  - Dynamic Chart using Pivot Table and VBA
   
• 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
  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)
   
• 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)
  Clustered and Stacked Column and Bar Charts
  Charting Passenger Volume with a Stacked Area Chart (TechTrax Article)
  Gantt Charts (stacked bar charts)
   
• Stacked-Clustered Column Charts
  Clustered and Stacked Column and Bar Charts
  Peltier Tech Cluster Stack Chart Utility and Documentation
   
• 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
  Dynamic Control Chart (zip file only)
  Woody Santy's Control Chart (zip file only, provided by Woody Santy)
  Moving Averages
  Histograms
  Custom Histograms
  Creating Paired Comparison Charts in Microsoft Excel (TechTrax Article)
  Interactive Parallel Coordinates Chart
  Statistics: Main Effects Plot
  Links to Statistics Resources
   
• 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
  Horizontal Stock Chart
  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
   
• 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
  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)
   
• Tornado Charts
  Tornado Charts and Dot Plots
   
• 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
  Columns on Two Axes
  Fill Below an XY Chart Series (XY-Area Combo Chart)
  Fill Between XY Chart Series (XY-Area Combo Chart)
  Brickyard Chart
  Excel Waterfall Charts (Bridge Charts)
  Horizontal Stock Chart
  Stock Chart with Added Series
  Box and Whisker Diagram (Box Plots)
  Probability Chart
  Dynamic Control Chart (zip file)
  Histograms
  Custom Histograms
  Variable Width Column Charts
  Clustered and Stacked Column and Bar Charts
  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
  
  Peltier Tech Chart Utilities
  - Peltier Tech Waterfall Chart Utility and Documentation
  - Peltier Tech Box and Whisker Plot Utility and Documentation
  - Peltier Tech Cluster Stack Chart Utility and Documentation
  - Peltier Tech Marimekko Chart Utility and Documentation
  - Peltier Tech Cascade Chart Utility and Documentation
  - Peltier Tech Dot Plot Utility and Documentation
  - Peltier Tech Panel Chart Utility and Documentation
  
  Self-contained add-in utilities
  See Installing an Excel Add-In and Installing an Add-In in Excel 2007 (Peltier Tech Blog)
  - Quick Chart Utility
  - Change Series Formula utility in How to Edit Series Formulas
  - Enhanced Export Chart Procedure
  - LOESS Utility for Excel
  - Error Bars in Excel 2007
  - Palette Chooser in Excel Chart Color Update
  
  Other useful tools
  - Align Chart Dimensions (zip file)
  - Switch X and Y (zip file)
  - Change Series Formulas
  - 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
  - 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 (Peltier Tech Blog)
  - Installing an Add-In in Excel 2007 (Peltier Tech Blog)
  
  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
  - Using Text Files to Save and Retrieve Information in Microsoft Excel (TechTrax Article)
  - 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
  - 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
  - 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)
  - 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
  - Creating Charts in a Grid
  - Pivot Table Programming
  - Export Chart as Image File
  - Enhanced Export Chart Procedure
  - Dynamic Chart Source Data (VBA)
   
• 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
  Excel Waterfall Charts (Bridge Charts)
  Peltier Tech 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
   

| # | 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 | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2013. 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