Can anybody point me towards a good resource on working with charts in VBA?

Most of the charts are column charts with historical sales data for different products, with a single line-chart data series representing the current fiscal year's sales. Ideally, I'd use a pivot chart and just build a big one, but I don't think it would handle that kind of multi-axis/multi-format chart.

That, and unfortunately I'm in a workplace that's somewhat pivot-phobic, as it were.