I need some help with charts:

I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this suing VBA???

PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is there any way that i can change this??
thank you.