Multiple chart series for Pivot Chart
 

Hi All,

I have a few thousand rows of data, with columns such as Calendar Quarter,
Calendar Month, Calendar Week, Ship Date (which feeds the aforementioned
columns by formula), Serial Number and Service Plan. There are several other
columns (ok, several dozen), but those are the relevant ones. For the sake
of ease, I have these sorted via PivotTable. By row, they're ordered by
Quarter and Month, and by Column they're ordered by the values in the Service
Plan column (either Service or Warranty [IE no service]). Currently, the
returned values in the data portion of the table are count of type (Service
or Warranty) and count percentage of sum. Is there a way to chart both the
quantities AND the percentages? My goal is to have a PivotChart which gives
both quantities of each in a column format and the percentage of each against
the sum charted as a line. Is this possible? Every time I attempt to change
the chart type on the percentage columns, it changes the chart type on both
the quantity and percentage. (IE: The PivotChart reads the percentage and
volume of Warranty as one series, and the percentage and the volume of the
Service as another, instead of reading them as four separate series.)

Any ideas?

Thanks,

Jamie W.