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!