Peltier Technical Services, Inc.
- Custom Excel Solutions

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whisker

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Miscellaneous Charts and Topics

Delink Chart Data
Protecting Charts
Brickyard Chart
Stacked Column Charts that Cross the X Axis
Tornado Charts

Delink Chart Data.

There are occasions when you may want to break the link between a chart and its underlying data. Maybe you copied the chart and pasted it into another workbook, and opening the other workbook brings up the dialog box asking whether you want to update the links to another workbook. This page describes ways you can make a copy of a chart that is not linked to the parent data.

Top of Page

Brickyard Chart.

I recently was asked about a "Brickyard Chart," a column chart that displayed variable width and height columns, and the columns build on each other. That is, each column's lower edge lines up with the previous column's upper edge. This page describes how to construct such a chart, building on Stephen Bullen's Variable Width Column Chart example, from FunChart5.xls on his web site, http://oaltd.co.uk.

Top of Page

Stacked Column Charts that Cross the X Axis.

Stacked column and stacked bar charts are handy chart types. And with invisible columns (no border and no fill in the column), you can get columns that float above the X axis of your chart, or that sink below the X axis. But what if you want to show columns that span the X axis? How can you make a bar start below the axis and end above it?

Top of Page

Tornado Charts.

A tornado chart is a bar chart commonly used to compare characteristics of two populations. A common use is to show the distribution of males and females among different age groups in the general population. Males would be shown in bars stretching to the left of the central line; females reaching to the right. This page shows how to make simple and more elaborate tornado charts.

Top of Page

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

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