Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Helen
 
Posts: n/a
Default Error bars for a single data point not whole series

how do i add error bars to a single data point and not the whole data series?
I need to display error bars showing the standard error but for each data
point individually. Is there a way to do this?
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Hi Helen,
Copy this data to a worksheet (the top cell is A1)
y +y -y
1 6 0.3 0.6
5 7 0.2 0.7
10 8 0.3 0.4
12 9 0.1 0.3

Make a chart (Line or XY) with the x and y data - first two columns
On chart, double click the data series to format it; open the Y-axis tab
Select Custom and fill in the box; for +Y enter C2:C5, for -Y enter D2:D5
This also works for x-errors
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Helen" wrote in message
...
how do i add error bars to a single data point and not the whole data
series?
I need to display error bars showing the standard error but for each data
point individually. Is there a way to do this?



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
scatter plot & label for a data point shabnam Charts and Charting in Excel 3 April 11th 05 06:37 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM


All times are GMT +1. The time now is 02:50 PM.

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

About Us

"It's about Microsoft Excel"