How do I add error bars unique to each data point?

G

Guest

I have a data series that I want to add error bars to, however I would like
to have unique error bar values for each individual point? Is this possible?
Thank you..
Glenn
 
A

Andy Pope

Hi,

On the error bar tab of the format dialog for a data series are 2 ref
edit boxes that will allow you to select a range of cells containing a
unique value for each point.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Add Error Bars for individual data points! 1
Convert Error Bars to Series and Colour 1
Excel Error bars on barplot not in series in excel 2016 0
Different values for error bars in series 1
how to add erro bars for each bar, rather than the whle series 1
Adding only vertical error bars to a single data point in a series 5
How to add different error bars to each data point in excel 2
error bars on bar chart in Excel 2007 1

Top