Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm stuck, I can't seem to be able to get excel to put in individual values
for my error bar I want to put on my bar graph. How do I rectify this? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
On Fri, 4 May 2007, in microsoft.public.excel.charting,
Slyther said: I'm stuck, I can't seem to be able to get excel to put in individual values for my error bar I want to put on my bar graph. How do I rectify this? What is it that you're doing to try to achieve this? You can't select a bar and choose a value in the error bar tab; that will always affect all the bars in the series, even if you only selected one bar. The facility that lets you alter the values by bar is the "range" at the bottom of the dialogue box. Enter your values in the spreadsheet, and then in the error bar dialogue tab select the range containing the values. All the bars will then have different error values, depending on what you've entered in the spreadsheet. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel should let you vary error bars for individual points | Charts and Charting in Excel | |||
Individual Error Bars | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
How do I plot error bars on 3D graphs? | Charts and Charting in Excel |