Macro for export to excel for different values based on chart field

[#1]

Hi all,

I need your help. I want to export the report to excel according to the values in the field of the chart.

Please help me

[Gysbert_Wassenaar]

Is this the kind of thing you're looking for: Loop Charts and Field Values - Excel Export Macro

[#3]

Thanks for your answer

But i dont want the excel for each values of the field Month. As in CH02, only Apr and Jan is displayed so i also want excels for only these two values

Waiting for an urgent reply

[#4]

Thanks for your answer 

But i dont want the excel for each values of the field Month. As in CH02, only Apr and Jan is displayed so i also want excels for only these two values

Waiting for an urgent reply

[Gysbert_Wassenaar]

Ok, so you didn't actually check to see what it does. It uses the getpossiblevalues function so it does not use every field value, only those that are either selected directly or possible as a result of selections in other fields.