Error bars overlap and are indistinguishable

[hadley]

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.

 

[Jon Peltier]

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]

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