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/
_______