ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Error bar values (https://www.excelbanter.com/excel-worksheet-functions/132155-error-bar-values.html)

Trichotos

Error bar values
 
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

ShaneDevenshire

Error bar values
 
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.
--
Cheers,
Shane Devenshire


"Trichotos" wrote:

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



All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com