ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Different error bar values within a data series? (https://www.excelbanter.com/charts-charting-excel/60195-different-error-bar-values-within-data-series.html)

Izzy

Different error bar values within a data series?
 
I am trying to put error bars into my graph but need the values to be
different. However, if I change one point it changes all of the points?

B. R.Ramachandran

Different error bar values within a data series?
 
Hi,

Create two columns, one for '+' errors and the other for '-' errors.

Rightclick on any data-point on your graph, "Format Data Series" -- select
the appropriate "Error Bars" Tab -- under Error Amount check "Custom" and
enter the ranges for the '+' and '-' values -- "OK"

Regards,
B. R. Ramachandran




"Izzy" wrote:

I am trying to put error bars into my graph but need the values to be
different. However, if I change one point it changes all of the points?



All times are GMT +1. The time now is 05:52 AM.

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