+ Reply to Thread
Results 1 to 2 of 2

Toggle Error Bars in XY Scatter Plot?

  1. #1
    Registered User
    Join Date
    12-28-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2013
    Posts
    31

    Toggle Error Bars in XY Scatter Plot?

    Is there a way to toggle error bars in a graph without losing your formatting and data ranges?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Toggle Error Bars in XY Scatter Plot?

    You could add another dummy series that is used to display the error bars.

    Depending of the error values this may cause the axes min/max values to change, if set to automatic. Again more dummy series containing min/max values, including error bars, could be added to maintain scales.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make clustered scatter plot with custom error bars?
    By jmikes in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-04-2020, 11:10 PM
  2. Horizontal error bars in scatter plot
    By cee_gee in forum Excel General
    Replies: 3
    Last Post: 05-04-2017, 07:19 PM
  3. Error Bars XY Scatter
    By DH123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-15-2016, 07:34 AM
  4. [SOLVED] creating step chart through scatter plot with x y error bars excel 2007
    By fight2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2015, 11:14 AM
  5. Excel Scatter Plot Error Bars All Show Same Standard Deviation
    By spaine in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-20-2015, 03:30 PM
  6. Creating scatter plot with mean/ SD error bars
    By aldo2014 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-24-2014, 10:48 AM
  7. [SOLVED] How do I plot mean and error bars in Excel?
    By rik827 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2006, 07:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1