Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 39
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart - multiple Data series Andy Charts and Charting in Excel 4 January 5th 07 06:39 PM
Multiple Pivot Chart Series Lists - Limit selections lurker111 Excel Discussion (Misc queries) 0 November 22nd 06 08:07 PM
Chart with multiple series officehub Charts and Charting in Excel 1 March 9th 06 07:00 PM
Pivot Chart - X,Y & Data Series Options Graham Haslehurst Charts and Charting in Excel 4 November 24th 05 03:51 PM
Can I have each series be a different field in a Pivot Chart? tyson12 Charts and Charting in Excel 1 June 30th 05 09:33 PM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"