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