Error bars overlap and are indistinguishable
 

Hello,
Does anyone have advice as to how to "nudge" a data series so that its
error bars can be seen instead of overlapping with the error bars of
another data series?
Thanks.


--
hadley
------------------------------------------------------------------------
hadley's Profile: http://www.excelforum.com/member.php...o&userid=31187
View this thread: http://www.excelforum.com/showthread...hreadid=508573

Error bars overlap and are indistinguishable
 

In a line chart, you're kind of out of luck, since the data points need to
line up with the categories. In an XY chart, you can add or subtract a small
amount from the X value to slide the point over.

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


"hadley" wrote in
message ...

Hello,
Does anyone have advice as to how to "nudge" a data series so that its
error bars can be seen instead of overlapping with the error bars of
another data series?
Thanks.


--
hadley
------------------------------------------------------------------------
hadley's Profile:
http://www.excelforum.com/member.php...o&userid=31187
View this thread: http://www.excelforum.com/showthread...hreadid=508573

Error bars overlap and are indistinguishable
 

Thank you very much! I didn't know about using XY & this has been a big
help to me.


--
hadley
------------------------------------------------------------------------
hadley's Profile: http://www.excelforum.com/member.php...o&userid=31187
View this thread: http://www.excelforum.com/showthread...hreadid=508573