Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
belinda001
 
Posts: n/a
Default adding multiple error bars to bar chart

i need some help!! i need to add error bars to a bar chart, and each value in
the series has a different standard error which has to be added. any ideas
how i can do this?? each time i try and change the error bar they all change
in the series!
Help me please!
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

On the Error bar dialog is the option to use a range as the values.
This can be used for both positive and negative values.

See Jon Peltier's page,
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

Cheers
Andy

belinda001 wrote:
i need some help!! i need to add error bars to a bar chart, and each value in
the series has a different standard error which has to be added. any ideas
how i can do this?? each time i try and change the error bar they all change
in the series!
Help me please!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Problem adding Series XValues to Chart using VBA Sean Curry Charts and Charting in Excel 0 March 14th 05 12:18 AM
adding certain cells in multiple worksheets in multiple workbooks Stephen via OfficeKB.com Excel Worksheet Functions 1 February 4th 05 08:31 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM
Adding a chart to a Word template linked to an Excel doc. Bobbie Excel Discussion (Misc queries) 0 January 3rd 05 08:07 PM


All times are GMT +1. The time now is 10:43 PM.

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

About Us

"It's about Microsoft Excel"