ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Error bars for a single data point not whole series (https://www.excelbanter.com/charts-charting-excel/21782-error-bars-single-data-point-not-whole-series.html)

Helen

Error bars for a single data point not whole series
 
how do i add error bars to a single data point and not the whole data series?
I need to display error bars showing the standard error but for each data
point individually. Is there a way to do this?

Bernard Liengme

Hi Helen,
Copy this data to a worksheet (the top cell is A1)
y +y -y
1 6 0.3 0.6
5 7 0.2 0.7
10 8 0.3 0.4
12 9 0.1 0.3

Make a chart (Line or XY) with the x and y data - first two columns
On chart, double click the data series to format it; open the Y-axis tab
Select Custom and fill in the box; for +Y enter C2:C5, for -Y enter D2:D5
This also works for x-errors
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Helen" wrote in message
...
how do i add error bars to a single data point and not the whole data
series?
I need to display error bars showing the standard error but for each data
point individually. Is there a way to do this?





All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com