I have searched for days to try to find information on how to attach a color to a series.

For example... I have a chart linked from Excel to PPT and I want my charts to alway use Red for "Tomato",Yellow for "Banana" etc. The series will change based on their rank in current sales. How do I alway keep the colors attached to the series no matter where it ranks?

Secondly,
Is there a way to automate text in PPT text boxes that read from Excel? I update the %change of sales and would like to use a text box rather than a chart title but want it to link to PPT based on the cell value in Excel.

Thanks for any help.

PS, I am a beginner so please go easy on the tech language! Thanks much.

J9