Phil -

Is it possible to individually color format Data Labels?

Yes. It takes two clicks to select one data label: the first click selects all
labels for a series. With one label selected, use your favorite formatting technique.

Can drop lines somehow be added to a trend line?

Add another XY series, and use error bars for the drop lines (negative, 100%).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______