Results 1 to 4 of 4

Thread: Dynamic Error Bars

  1. #1

    Dynamic Error Bars



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Needed are horizontal and vertical error bars to the chart edge, originating from the most current X-Y, based on index formulas. As new values are posted, the error bars update automatically.
    Attached Files Attached Files

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    37
    Articles
    0
    Hi Phil,

    In order to have X & Y error bars you need to use a X-y scatter chart rather than Line, which will only allow only Y error bars.
    You can make the error bars touch the X and Y axis by setting the Minus value to 100% for both error bars.

    Finally because the xy-scatter does not do dates well you will need to fix the x-axis minimum value.

    See example 308.xls
    Cheers
    Andy

    www.andypope.info

  3. #3
    Hi Andy - Thanks for your reply. My thinking was that with the two index formulas, I could use them as a single-point scatter. So there would be two things going on at once: 1. the line chart, and 2. the single-point - with a single horizontal and single vertical error bar (or something looking the same).

    Your solution is correct; however, only needed is the current value lines, not every data point.

    Is this possible? Seems this would not be especially strange in Excel graphing. The basic idea is to localize values on the axes when there are a lot of values plotted, say a hundred or so. Your thoughts?

  4. #4
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    37
    Articles
    0
    The simplest thing is to add another data series with only the 1 point. Apply the error bars to this series.
    Attached Files Attached Files
    Cheers
    Andy

    www.andypope.info

Tags for this Thread

Posting Permissions

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