Add Error Bars to Individual Points in Excel 2008 for iOS

AI Thread Summary
Error bars can be applied to individual points in Excel, but the method varies by version. In Excel 2008 for iOS, users have reported limitations in customizing error bars for individual data points. However, in the Mac OS version (2011), there is a feature that allows users to select different error values for each point by clicking on chart icons next to the error value fields. This enables the use of distinct error values for both positive and negative error bars. A suggested workaround for users facing limitations is to split data points into separate series, allowing for the application of different error bar settings to each series.
Alaya1
Messages
2
Reaction score
0
Hi,

Okay, I'm in a bit of a rush: Can you put error bars on INDIVIDUAL points in Excel? I found the "custom" setting for the error bars, but you can only add custom error bars for ALL points. I'm looking for a way to mark errors for each point individually. Is there any way to do that?

I have Excel 2008 for iOS.

Thanks already,
Alma
 
Physics news on Phys.org
I don't know about the IOS version, but in the Mac OS version (2011), when I get the box with fields for the + and - error values, there are little chart icons next to the fields. Clicking on one of those icons let's me select a column (or row) that contains the error values, which can be different for each point. They can also be different for + and -.
 
I don't do Excel, but, can you plan ahead and split your points into two different series so that you can apply the error bar setting to one of them?...just an idea, not knowing any better.
 
Back
Top