Thread: Chart - gradient error handling

James,

Welcome to the forum, but you really should read the rules first. You are not allowed to post the same request to more than one forum at a time. - See Rule 5.

In any case, the more obvious forum to have chosen if you'd have studied this site a little more, would have been Excel Charting.

On this occasion and since you are new here I won't give you an infraction this time, but please PM me to acknowledge you have understood the rules. They are there for a reason.

In the meantime I will move this thread for you and cancel the other one.

Rgds

Hi,

Does the following offer any assistance?

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

HTH

a little but it still doesnt tell me the error on the gradient calculated
thanks though

Hi,

If I've understood your requirement, you need to plot the x,y values with errors on an xy scattergraph, select one of the points and click the 'Add Trendline' option.

Now select the Trendline and choose the Format Trendline option, click the Options tab

Then choose the 'Display equation on Chart' box to see the gradient (the second term) or the 'Display R^2 value to see the error.

HTH