Combining graphs on Pivot Chart

[daveybohh]

Hi there,

I have a problem graphing a second data set onto a pivot chart. I have tried to construct a simplified version for illustration.

http://imageshack.us/photo/my-images/600/pivottable.jpg/

My "sub-system" series is graphed on the chart (shown in red) and I would like to graph the "system" series also (shown in blue).

I would like the blue "system" bars to cover all of the "sub-systems". For example Car-A is plotted but not Car-B or Car-C.

I could copy and paste the pivot table and manually enter values in the "system" column but this would be very time consuming and am wondering if there is an easier way.

Any ideas greatly appreciated.

Thanks in Advance.

Dave