Making Thermometer graphs in Pivot Charts

[Legacy 61783]

Hi,

I have to create some sales graphs as Thermometers. As I have several nested items of data, I thought it would be nice to use a Pivot Chart to be able to easily switch between data sets. Is it possible to create these types of graphs in a Pivot Chart?

I do this in a normal graph by creating 2 data sets, one the Actual, the other the Target. Select the generic chart type, then set the Overlap to 100.

Thanks,

Colin