Reference Using Data Filters as Charts Filters
Product Value Type Value
While Value Type Sales is selected Heading is Sales
Expenses is Expenses
Profits is Profits
I have altered as Month Year Value
During selection of Year 2007,2008,2009 the Heading Chages
But while Selecting All Blank Heading
I need as 2007 - 2009
I have tried by refering to Cell All Works But selective does Not Work
Month are from Jan - Dec
Year 2007, 2008, 2009 OR All
Please Advise
Product Value Type Value
While Value Type Sales is selected Heading is Sales
Expenses is Expenses
Profits is Profits
I have altered as Month Year Value
During selection of Year 2007,2008,2009 the Heading Chages
But while Selecting All Blank Heading
I need as 2007 - 2009
I have tried by refering to Cell All Works But selective does Not Work
Month are from Jan - Dec
Year 2007, 2008, 2009 OR All
Please Advise