View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sugargenius sugargenius is offline
external usenet poster
 
Posts: 26
Default pivot chart exclude rows

I'm building a pivot chart that plots performance metrics over time
(SV, CV, cpi, spi, etc). I've created a pivot table with rows for
BCWS, BCWP, ACWP (source data) and calcuated items for the metrics.
The columns are fiscal period end dates:


JAN07 FEB07 MAR07
BCWS
BCWP
ACWP
SV
CV
CPI
SPI

I want 2 charts: cpi vs spi and cv vs sv. How do I suppress the other
rows in the charts?

Thanks
Woody