I am using the subtotal feature to create many charts. however, everytime i
query excel and do a new subtotal, my previous chart gets erased. i would
like to save my the different charts i create from the subtotal feature.
i've tried to copy and paste and that does not work. and i do not want to
save it as a picture because i would like to be able to modify the charts.
thanks for your help!

Hi
You can use "Pivot Chart report" to solve your problem. if you are not
clear, please do mail (attach file also) to me

Thanks and regards
Muhammed Rafeek m

"roxanne" wrote:

I am using the subtotal feature to create many charts. however, everytime i
query excel and do a new subtotal, my previous chart gets erased. i would
like to save my the different charts i create from the subtotal feature.
i've tried to copy and paste and that does not work. and i do not want to
save it as a picture because i would like to be able to modify the charts.
thanks for your help!