pivot chart exclude rows

S

sugargenius

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
 

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

Top