Charting Add-Ins by Peltier Technical Services

Jon Peltier of Peltier Technical Services has written seven Excel Add-Ins (as of this writing) for charting excellence. You too can have professional-grade charts using any of the following utilities.

Jump to: Waterfall Charts • Box and Whisker Charts • Cluster Stack Charts • Panel Charts • Marimekko Charts • Dot Plots • Cascade Charts

PTS Waterfall Chart Utility

Create Waterfall (Aka Bridge) Charts Easily

The PTS Waterfall Chart Utility allows you to create professional waterfall-style charts easily. Sort and add labels as well. Easy to install and customize. You can also create waterfall (aka bridge) charts from your own VBA procedures!

Available for Excel 2000 through 2010

When you install the PTS Waterfall Chart Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in adds a new worksheet, constructs the data table with appropriate formulas, and creates the Waterfall chart for you. Simple!

VBA Usage

You can call the PTS Waterfall Chart Utility from your own VBA programs. Just call the main function as follows:

Function PTS_WaterfallChart(rngData As Range, _
			 bFirstLabels As Boolean, _
			 bDataLabels As Boolean, _
			 lSortData As SortData) _
			 As Chart

Click here to purchase or read more about the PTS Waterfall Chart Utility

PTS Box and Whisker Chart Utility

Box and Whisker Plots Are Simple Now

The PTS Box and Whisker Chart Utility lets you create box and whisker charts easily. Use raw data or compiled statistics, and show or hide outliers. You can also create charts from your existing VBA procedures. Choose from several statistically valid quartile definitions, and you can orient the chart horizontally or vertically.

Available for Excel 2000 through 2010

When you install the PTS Box and Whisker Chart Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in adds a new worksheet, constructs the data table, and creates the Box plot for you. The chart can be customized with your own color and font schemes.

VBA Usage

You can call the PTS Box and Whisker Chart Utility from your own VBA programs. Just call the main function as follows:

Function PTS_BoxWhiskerChart(rngData As Range, _
				         bByColumn As Boolean, _
				         bFirstLabels As Boolean, _
				         bVertical As Boolean, _
				         lBoxWhiskerChartStyle As BoxWhiskerChartStyle) _
				         As Chart

Click here to purchase or read more about the PTS Box and Whisker Chart Utility

PTS Cluster Stack Utility

Easy Clustered and Stacked Column Charts

Professional cluster stack column charts can be created quickly and easily with the PTS Cluster Stack Utility. Define the number of stacks per cluster, and the number of columns per stack. Call the chart creation code from your own VBA procedures.

Available for Excel 2000 through 2010

When you install the PTS Cluster Stack Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in adds a new worksheet, constructs the data table, and creates the Cluster Stack chart for you. The chart can be customized with your own color and font schemes.

VBA Usage

You can call the PTS Cluster Stack Utility from your own VBA programs. Just call the main function as follows:

Function PTS_ClusterStackChart(ChartData As Range, _
					[DataLayouts]) _
					As Chart

Click here to purchase or read more about the PTS Cluster Stack Utility

PTS Panel Chart Utility

Professional looking Panel Charts are now just a few clicks away

Also called trellis charts. This addin lets you choose between panel charts and the more traditional bar charts. Includes numerous end-user configurable options:

The Panel Chart Utility will turn a three-column range of data into a panel chart, an array of dot plots in separate panels of the chart. The first column of data separates the data into the separate panels, the second column contains the categories plotted on the vertical axis of each panel, and the third column contains the values which are plotted against the horizontal axis. Each panel has identical axes.

Available for Excel 2000 through 2010

When you install the PTS Panel Chart Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

VBA Usage

To call the PTS Panel Chart Utility from your VBA Programs, call the charting function like this:

Function PTS_PanelChart(ChartData As Range,
                     [PanelChartStyle As PanelStyle = PanelStyleDotPlot],
                     [OverrideRows As Long = 0],
                     [OverrideColumns As Long = 0],
                     [SortField1 As SortLabels = SortLabelsIncreaseValue],
                     [SortField2 As SortLabels = SortLabelsIncreaseValue])
                     As Chart

Click here to purchase or read more about the PTS Panel Chart Utility

PTS Marimekko Chart Utility

Quickly create professional Marimekko (Aka Mosaic) charts

No programming or formula skills required — enter your values and the PTS Marimekko Chart Utility performs all the necessary calculations on your data to produce the chart. Like the other PTS Charting Utilities, you can also create Marimekko charts from your own VBA procedures.

Available for Excel 2000 through 2010

When you install the PTS Marimekko Chart Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in adds a new worksheet, constructs the data table, and creates the Marimekko chart for you. The chart can be customized with your own color and font schemes.

VBA Usage

You can call the PTS Marimekko Chart Utility from your own VBA programs. Just call the main function as follows:

Function PTS_MarimekkoChart(ChartData As Range, _
				        SegmentsByColumn As Boolean) _
				        As Chart

Click here to purchase or read more about the PTS Marimekko Chart Utility

PTS Dot Plot Utility

Professional Dot Plots Available Now

Dot plots are like line charts, but with dots instead, and are displayed vertically with changing values. But don't struggle trying to get Excel to create this chart manually — using this add-in makes creating dot plots a snap!

Available for Excel 2000 through 2010

When you install the PTS Dot Plot Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in constructs the appropriate data table and creates the Dot plot for you. The chart can be customized with your own color and font schemes as usual.

VBA Usage

You can call the PTS Dot Plot Utility from your own VBA programs. Just call the main function as follows:

Function PTS_DotPlot(ChartData As Range, _
				FirstLabels As Boolean, _
				HGridLines As Boolean, _
				VGridLines As Boolean, _
				ConnectingLines As Boolean) _
				As Chart

Click here to purchase or read more about the PTS Dot Plot Utility

PTS Cascade Chart Utility

Create Cascade Charts quickly and easily

Using the PTS Cascade Chart Utility you can create your own handsome cascade charts. Compare different elements over the same time period, similar to a Marimekko chart. Effortlessly create and customize your chart and impress your boss or your clients.

Available for Excel 2000 through 2010

When you install the PTS Cascade Chart Utility in Excel 2000 through 2003, a new menu item is added to the Worksheet Menu Bar. In Excel 2007+, it adds a new tab to the Ribbon. If you already have other PTS Charting Utilities installed, they are added to the existing menu item or tab.

The add-in adds a new worksheet, constructs the appropriate data table and creates the Cascade chart for you. The chart can be customized with your own color and font schemes.

VBA Usage

You can call the PTS Cascade Chart Utility from your own VBA programs. Just call the main function as follows:

Function PTS_CascadeChart(ChartData As Range, _
				      CascadeStyle As ptsCascadeStyle) _
				      As Chart

Click here to purchase or read more about the PTS Cascade Chart Utility

Multiple Item Discounts

When you purchase multiple utilities from PTS in one order, the following discounts apply:

• When two items are in the cart, you will receive a 5% discount
• When three items are in the cart, you will receive a 10% discount
• When four items are in the cart, you will receive a 15% discount
• When five or more items are in the cart, you will receive a 20% discount
• When ten or more items are in the cart, you will receive a 25% discount

Note: These are affiliate links.