Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
hadley
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
hadley
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"