Share via

How to fix the error bar where the line goes beyond the cap

Carmen Lee 0 Reputation points
2026-05-13T04:47:39.77+00:00

User's image

The value chosen for error bar is customized standard deviation of my data

Microsoft 365 and Office | Excel | For education | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doris V 1,695 Reputation points Microsoft External Staff Moderator
    2026-05-13T06:46:51.5233333+00:00

    Dear @Carmen Lee,

    From your image, I understand that the chart uses custom error bars based on the standard deviation of your data. On the chart, an error bar line appears to extend past (or not align with) the cap.

    To better assists, could you please confirm following information:

    • Are error bars applied to one series only, or all series in the chart?
    • In Format Error Bars > Custom > Specify Value, are the Positive and Negative ranges the same length as the number of columns for that series?
    • Are you using the same SD range for every series, or does each series have its own SD range?
    • Which Excel version and platform are you using (Windows or Mac, Microsoft 365/Excel 2021, etc.)?
    • To reproduce and test the same behavior, could you please share a small sample of the data used for the chart (you can anonymize it)?

    In the meantime, could you please try some steps to test:

    1/ Confirm you are editing the correct series’ error bars

    • Click an error bar once (selects error bars).
    • Open Format Error Bars and confirm you are formatting the intended series.

    2/ Remove duplicates and re-add only once

    • Select the error bars for the series.
    • Press Delete to remove them, then add again: Chart Elements (+) > Error Bars > More Options.
    • Choose Custom > Specify Value, then select your SD cells for Positive/Negative.

    3/ Double-check the custom SD ranges

    • Ensure the selected SD cells match the number of plotted points in that series (1 SD value per bar).
    • Ensure the SD values are referencing the correct SD calculation cells (not raw data).

    4/ Add more space using axis scale

    • Right-click the vertical axis > Format Axis.
    • Increase the Maximum bound to give the error bars more room.

    Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. Your detailed response will help us diagnose and investigate the issue more efficiently.

    I truly appreciate your patience and understanding. If I misunderstood what you’re looking for, feel free to let me know or share a screenshot. I’d be happy to help further!

    Thank you for your cooperation.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  2. AI answer

    2026-05-13T04:47:52.5633333+00:00

    Excel is drawing the error bar correctly: the long gray line is the full error bar, and the small horizontal line is the cap. The bar itself is simply shorter than the error bar, so the bar does not “stop” at the cap.

    To make the error bar appear visually correct and avoid the line extending far beyond the cap, adjust the error bar settings rather than the bar:

    1. Click the chart, then click the data series whose error bars need fixing.
    2. Use the Chart Elements button next to the chart and select Error Bars → More Options.
    3. Under Vertical Error Bar, change the error amount so it matches the intended scale:
      • Use a smaller Percentage, or
      • Use a smaller Standard Deviation multiplier, or
      • Choose Custom and supply upper/lower values that match the actual standard deviation of the data.
    4. If needed, also change the direction (Plus, Minus, or Both) and end style (cap on/off) in the same pane so the cap is clearly visible.

    If the current custom values are too large (for example, using a multiple of the standard deviation instead of the standard deviation itself), Excel will draw an error bar that is much longer than the column, which is what the screenshot shows. Reducing those values or switching to a built‑in option like Standard Deviation or Standard Error will keep the error bar within a visually reasonable range.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.