|
Commercial Utilities developed by Peltier Technical Services |
Waterfall Chart
|
Books that I own and use while developing in Excel |
|
Excel or charting related products and services which I use or feel are worthwhile additions |
|
2008 US East Coast Excel User Conference |
Jon's Excel and Charting Pages - Index. |
- PTS Blog
The PTS Weblog
- What's New
Recent additions to this web site
- 3-D Charts
The Perils of Being in 3D (PTS Blog)
Surface and Contour Charts in Microsoft Excel (TechTrax Article)
- Add-Ins
Installing an Excel Add-In (PTS Blog)
- Area Charts
XY Area Chart: Fill Below an XY Series
XY Area Chart: Fill Between XY Series
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 (PTS Blog)
- 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 (PTS Blog)
Secondary Axes in Charts (PTS Blog)
Secondary Axes that Work - Proportional Scales (PTS Blog)
Arbitrary Axis Scale
Broken Y Axis
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
Columns on Two Axes
Create Multiple Combination Charts in Excel (Computor Companion article)
Axis Label Cut Off
Category Axis Tricks for Line and Area Charts - 1 (PTS Blog)
Category Axis Tricks for Line and Area Charts - 2 (PTS Blog)
Chart with a Dual Category Axis (PTS Blog)
Using Pivot Table Data for a Chart with a Dual Category Axis (PTS Blog)
- Axes - Custom Axis Scales using Dummy Series
Arbitrary Axis Scale
Arbitrary Gridlines
Arbitrary Gridlines, Take Two (zip file)
Arbitrary Gridlines and Axis Labels
Broken Y Axis
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
Horizontally Banded Chart Background
Highlight Certain Time Periods in a Chart (PTS Blog)
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 Plots
- Horizontal Box and Whisker Plots
- Vertical Box and Whisker Plots
- Bridge Chart (Waterfall Chart)
Waterfall Charts (and Utility)
- Bubble Charts
Bubble Charts in Microsoft Excel
Control Bubble Chart Bubble Sizes
- 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
Tornado Charts
Columns on Two Axes
XY Area Chart: Fill Below an XY Series
XY Area Chart: Fill Between XY Series
Brickyard Chart
Waterfall Charts (and Utility)
Stock Charts
Box and Whisker Plots
Probability Chart
Dynamic Control Chart (zip file)
Histograms
Column Chart with Variable Width Columns
Variable Width Column Charts
Clustered-Stacked Column Chart
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
- Colors
Using Colors in Excel Charts (PTS Blog)
- Column Charts
Add a Line to a Column or Line Chart.
Dynamic Column Chart
Columns on Two Axes
Histograms
Stacked Column Charts that Cross the X Axis
Floating Column Charts
Vertical Box and Whisker Plots
Waterfall Charts (and Utility)
Clustered-Stacked Column Charts (PTS Blog)
Clustered-Stacked Column Chart
Column Chart with Horizontal Line Segments
Column Chart with Variable Width Columns
Variable Width Column Charts
Build a Column or Bar Chart with Images
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
XY Area Chart: Fill Below an XY Series
XY Area Chart: Fill Between XY Series
Combination Clustered Columns with Clustered Lines
Column Chart with Horizontal Line Segments
Clustered-Stacked Column Chart
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 (PTS Blog)
- Command Bars
Excel Menus and Command Bars
Custom Drawing Command Bars
How To: Assign a Macro to a Toolbar or Menu (PTS Blog)
- 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
Simple Conditional Charts
Simple Conditional Charts - 2
Special Format for Minimum and Maximum
Use an Arrow to Indicate Special Points
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)
- 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)
Woody Santy's Control Chart (zip file only, provided by Woody Santy)
- 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
- Dashboards
Effective Dashboards
Dashboards (PTS Blog)
Arranging Charts in a Grid (PTS Blog)
Creating Charts in a Grid (PTS Blog)
- 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
- Dial Chart
Speedometer Chart
- Dot Plots
Dot Plots
Tornado Charts and Dot Plots (PTS Blog)
- Drop Lines
Drop Lines in Excel Charts
- Dummy Series
Dummy Series (overview)
Axes - Custom Axis Scales using Dummy Series
Floating Column Charts
- Dynamic Charts
Dynamic and Interactive Charts (overview)
Dynamic Charts (PTS Blog)
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 (PTS Blog)
Dynamic Chart using Pivot Table and VBA (PTS Blog)
Dynamic Ranges to Find and Plot Desired Columns (PTS Blog)
Split Data Range into Multiple Chart Series without VBA (PTS Blog)
VBA to Split Data Range into Multiple Chart Series (PTS Blog)
Dynamic Chart Source Data (VBA) (PTS Blog)
Dynamic Chart Links
- Early Binding (VBA)
Early vs. Late Binding
- Error Bars
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.
Arbitrary Gridlines
Horizontal Box and Whisker Plots
Vertical Box and Whisker 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 (PTS Blog)
Error Free VBA
- 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)
- Exponential Notation
Exponential Notation Axis Labels
- Export Charts
Export Chart as Image File (PTS Blog)
Enhanced Export Chart Procedure (PTS Blog)
Image File Type Comparison of Exported Charts (PTS Blog)
- FAQs
Microsoft Excel Charting FAQs (TechTrax Article)
- Fill Effects
XY Area Chart: Fill Below an XY Series
XY Area Chart: Fill Between XY Series
Apply Fill Color Between Lines in a Chart (TechTrax Article)
Line and Fill Effects in Excel Charts Using VBA
Line and Fill Effects in Excel Radar Charts Using VBA
Horizontally Banded Chart Background
Background Effects
- Floating Bar Charts
Horizontal Box and Whisker 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
Vertical Box and Whisker Plots
Waterfall Charts (and Utility)
- 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
Custom Series Formatting
Custom Markers
Using Colors in Excel Charts (PTS Blog)
Build a Column or Bar Chart with Images
Simple Conditional Charts
Simple Conditional Charts - 2
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)
Special Format for Minimum and Maximum
Squeeze Columns Together (Squeeze Out Blank Columns)
Column Chart with Variable Width Columns
Variable Width Column Charts
Clustered-Stacked Column Chart
Number Formats in Excel
Control Bubble Chart Bubble Sizes
Line and Fill Effects in Excel Charts Using VBA
Connect Two XY Series (PTS Blog)
Connect Two XY Series with Arrows (VBA) (PTS Blog)
XY Area Chart: Fill Below an XY Series
XY Area Chart: Fill Between XY Series
Apply Fill Color Between Lines in a Chart (TechTrax Article)
Invert if Negative
Area Chart - Invert if Negative (PTS Blog)
- 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 (PTS Blog)
Tornado Charts
Bad Graphics - Funnel Chart (PTS Blog)
- 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)
- Late Binding (VBA)
Early vs. Late Binding
- Layered Charts
Stacked Charts With Vertical Separation
- 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
- Marimekko Chart
Matrix Chart
- 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
- Name
Chart Names
- New Additions
Recent additions to this web site
- 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)
- 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)
- 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
- 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 Between XY Series
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)
- 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
Self-contained add-ins
- Quick Chart Utility (web page, link to zip file)
- Box and Whisker Chart Maker (web page, link to zip file)
- Dot Plotter (web page, link to zip file)
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
- Enhanced Export Chart Procedure (PTS Blog)
- VBA
VBA Macros
- How To: Record Your Own Macro (PTS Blog)
- How To: Fix a Recorded Macro (PTS Blog)
- How To: Use Someone Else’s Macro (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)
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
- 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.
- 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)
