Hi guys,
I am new to Pivot Tables, I have managed to create a PT using the VBA (Thank MrExcel to help me understand the concept of PTs)
I am trying to create a multiple Pivot Charts from 1 PT.
But everytime I add a chart, it shows me everything in the chart. I really dunt want this.
All I want to programatically create charts for selective datafields and selective report filter.
I really dunt want to create more than 1 PT, I tried it but my Excel crashed :S....
Please Help
Regards,
I am new to Pivot Tables, I have managed to create a PT using the VBA (Thank MrExcel to help me understand the concept of PTs)
I am trying to create a multiple Pivot Charts from 1 PT.
But everytime I add a chart, it shows me everything in the chart. I really dunt want this.
All I want to programatically create charts for selective datafields and selective report filter.
I really dunt want to create more than 1 PT, I tried it but my Excel crashed :S....
Please Help
Regards,