Automatically Ignore/Filter/Sort Blanks from a Pivot Table before creating Chart Using VBA

Automatically Ignore/Filter/Sort Blanks from a Pivot Table before creating Chart Using VBA

Dear Forum,

I am creating Charts/Graphs from a a Pivot table used Range, everything is working fine as I am having only PivotTable1 in the ActiveSheet and I have modified my Recorded Macro to create a Clustered Column Chart.

Now the problem i faced was that in one of the Data I am using has some blank values and therefore in the Chart I get a Data Series with the Blank Value as one of the element..

Now I can always turn off the Blank Values by filtering , but is there a way to do the same using VBA as my Chart is created at the click of a Command Button..

So what I am expecting is to have a macro which will filter the Blanks out of the equation for the Chart Data and I will have all TRUE elements for the Chart..

Thanks in advance

Warm Regards
e4excel

I just Recorded a Macro to perform the Task of Unchecking the Blanks from the Pivot Data and which worked fine however there is a catch that it requires the [ PivotFields("Treatment") ] to be provided and what I need is to get this done automatically without specifying any thing like the PivotFields..

So is it possible to do so..

Please Login or Register  to view this content.

I am looking for a generic code/solution where for any Pivot Data without entering any detail at the click of a Button before the Clustered Column is created it will check for the Blanks and if they exist it will uncheck the blanks and then on that data a Chart would be made

Dear Forum,

IS there a way to overcome this or I have thought of an workaround where I would have to put all of the Column Headings in the code below :

Please Login or Register  to view this content.

Regards
e4excel