Error bar values

[Guest]

I recently posted a question about error bars. Jon Peltier help a lot. Now
that i know how to create the error bars, i was wondering if it is possible
to place the value attached to the error bar on the chart itself, above the
bar. If anyone can help i would appricate it.

Trichotos

 

[Guest]

You could do that two ways at least - create a new series whose value force
them above the error bars and then attach data labels for them or you could
use the XLChartLabeler program which is free on the internet. Also John
Walkenback has an add-in to do this for you. These add-ins allow you to
connect the data labels to any range in the spreadsheet and to move the data
labels any distance from the data points.