- Recent
- Popular
- Tags (0)
- Subscribers (4)
- Tertiary Axes
- I once had a page on this site that showed how to generate additional axes in a chart. With the technique you could go beyond primary and secondary axes, to tertiary and quaternary axes, and even more. Given that charts with just primary and secondary axes can be confusing, a tertiary axis is just overkill. Multi-axis charts can be cluttered and confusing, even when using a custom color scheme to help identify each series with its corresponding axis. I propose using Panel Charts as a substitute for charts with confusing multiple axes.
- Introducing the PTS Blog
- I have started a blog so I can show off some of the projects I have worked on, share some Excel and Charting tips and techniques, show how to make some tricky charts that people ask about in forums and newsgroups, and talk about the various utilities I am working on. The first one, my Box and Whisker Chart Utility, will hit the market within a week or so. I hope to post two or three times each week. Stay tuned.
- Interactive Parallel Coordinates Chart
- A parallel coordinates chart, or profile plot, is a useful way to compare several sets of observations of a combination of different factors. The entire population, or at least a broad set of data, is generally shown in a subdued color while one or more individuals are highlighted for inspection. This article shows how to build an interactive parallel coordinates chart in Excel to compare selected quarterbacks across a number of offensive categories.
- Waterfall Charts and Utility - Updated Utility (Jan 2008)
- Waterfall charts are a special type of floating column charts. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value. An invisible column keeps the increases and decreases linked to the heights of the previous columns. Unfortunately, Microsoft Excel does not have a built in Waterfall chart type. This page shows how to arrange your data and create a waterfall chart. This page links to a utility which can be used to generate Waterfall charts from worksheet data. The utility has recently been updated: it installs into Excel 2007 with a button on the Add-Ins tab of the ribbon, and it avoids an infrequent error on shutdown of Excel. Prior versions of this utility should be uninstalled prior to installing this new version.