Trendline covering up error bars

[itgoeson]

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
[email protected]

[Jon Peltier]

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
> [email protected]
>
>

[itgoeson]

Thanks for your help! Great idea to just plot it as a new data set. However, I had some problems... see post http://www.excelforum.com/showthread.php?t=392368

[Jon Peltier]

Yes, I've answered in the followup thread. You should be flying now.

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


itgoeson wrote:

> Thanks for your help! Great idea to just plot it as a new data set.
> However, I had some problems... see post
> http://www.excelforum.com/showthread.php?t=392368
>
>