Multiple chart series for Pivot Chart

M

MJW

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Multiple chart series for PivotChart 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Chart SERIES OFFSET 5
Odd Chart Format Results 1
Contour Chart - Find Vals for Shaded Areas 0
Remove series from Pivot Chart 2
MS Project. Real progress of the project, % complete 1

Top