Chart Problems

Hello,

SOMEBODY PLEASE HELP!!!!
I've seen Palmetto's response, and I need additional assistance.
My chart skills have gotten rusty. Please bear with me.
1. If your data is in one worksheet and the chart will be in another -- Which is better, to insert chart on the worksheet where the data is, and then move the chart? Or to go to the worksheet where the chart will be? How do you link the data?
2. How do you change the color of a pie slice or a bar column?
3. If I have to use a text box, how do I put a formula referring back to my data? I can't get the text box to stay on the screen.
4. When I use the handles and make my chart bigger, the title falls off the page and I can't get it back. I have no room underneath the bottom of the pie.
5. How do you add a footer to the chart? I don't mean the worksheet - I mean at the bottom of the chart. Thanks. Posted in Charting forum.