I am trying to do box and whisker types of plots. The only way to do this,
as I can see, is to use what Excel calls "stock plots".

1. Is there another way to get box and whisker plots from Excel?
2. When I have the plots in one file and the source data in another, and the
source data file is not open, the plots will get messed up - x scale redrawn.
Is there any way around that?
3. Is there any way to have the up-down bars such that I can have one or
more sets of bars a different color from the rest of the bars?

TIA.