#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error bar values Trichotos Excel Worksheet Functions 0 February 23rd 07 06:43 PM
Display Error Bar values on chart? [email protected] Charts and Charting in Excel 1 November 18th 06 05:19 AM
Ignoring error values in a formula Nicola Excel Worksheet Functions 1 September 14th 06 04:07 PM
Hiding error values in cells brisen09 Excel Worksheet Functions 1 August 16th 06 09:20 AM
Different error bar values within a data series? Izzy Charts and Charting in Excel 1 December 13th 05 04:46 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"