Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple chart series for PivotChart
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Pivot Chart - multiple Data series | Charts and Charting in Excel | |||
Chart with multiple series | Charts and Charting in Excel | |||
Pivotchart Multiple series question | Charts and Charting in Excel | |||
Floating Bar chart with multiple series | Charts and Charting in Excel |