Archive for Thursday, March 6th, 2008
Clustered Bars as an Alternative to Stacked Bars or Bubbles
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
Last fall, Many Eyes posted a bubble chart to show US Beer Shipments by Supplier. They made the chart using a visualization technique they call the matrix chart, which essentially supplies a matrix of rows representing one parameter, columns representing another, and a graphic at each grid location representing some value. In this case, the [...]
Posted: Thursday, March 6th, 2008 under Chart Types, Charting Principles, Example Charts, Formatting.
Comments: 5
Quick VBA Routine: XY Chart with Axis Titles
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
Someone asked in the newsgroup how to create an XY chart in Excel that uses the label at the top of the columns of X and Y data for the axis titles. That’s not built in, but it’s not hard to do if you know a little VBA. I’ve taken an example from my web [...]
Posted: Thursday, March 6th, 2008 under VBA.
Comments: 1
