A chart has certain layers, and the orcer of the layers cannot be
changed, only the order of objects within a layer.
Trendlines go on top of almost anything in the chart. You could double
click the trendline and choose a thinner line style, you can double
click on the error bars, and choose a more conspicuous style.
You could also use the coefficients to plot your own trendline as an XY
Scatter series, and it should be plotted in a layer beneath the error bars.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
itgoeson wrote:
Hello--
How can I change the order of the trendline and data set? My trendline
is covering up my error bars... I want them on top. Any way to do
this?
Thanks,
Jennifer