Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
You need to use Custom Series to get just one error bar
best wishes
How to add an error bar to a single data point in Excel 2016.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
On my scatter plot chart, I need to add a vertical line to the point of the maximum x-value. I can only find help for error bars at all data points. What do I do?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Answer accepted by question author
-
Anonymous
2018-03-31T12:18:58+00:00
Answer accepted by question author
Answer accepted by question author
-
Anonymous
2018-03-30T20:54:33+00:00 Hi ebarrow1,
You need to have an existing chart to create the vertical error bar. We suggest that you check this link for the steps and get more information about adding, changing, or removing error bars in a chart.
Don’t hesitate to update this thread if you have further questions.