Add Error Bars to Individual Points in Excel 2008 for iOS

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 2K views
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.