|
Peltier Tech
Chart Add-Ins
Excel Dashboards
Books at Amazon.com
 
 
|
|
Miscellaneous Charts and Topics
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
|
|
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 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
|
|
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
|
|
|
