Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

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 Tables - Exclude Rows With Zero Balances bobs Excel Discussion (Misc queries) 2 January 10th 08 01:53 PM
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Exclude unused value in chart scott Charts and Charting in Excel 2 September 24th 06 05:44 PM
Exclude Chart Items blatham Excel Discussion (Misc queries) 0 August 3rd 06 03:40 PM
Copy rows, but exclude blank rows Mary[_9_] Excel Programming 1 November 1st 05 07:21 AM


All times are GMT +1. The time now is 11:31 PM.

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"