If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
X error bar Excel 2007
I have 1 serie with 20 datapoints, defined as line-type graph
A 2nd series represent the average of all 20 datapoints an is located at position 20 on the X-axis, defined as scatter-type I want to draw a line from this point towards the Y-axis, to mark the average. For this I use the X-error bar with a fixed value of 19; 20 cannot be used because the Y axis would shift 1 tick mark to the right (?) The number of datapoints is growing (here 20) and is located in a particular cell. Can I use this ref as custom error bar value but minus 1 so I don't have to change the value every time the number of datapoints is increasing ? |
#2
|
|||
|
|||
X error bar Excel 2007
You can use another cell that has a formula which does the subtraction for
you. You can only use link formulas, not calculation formulas, in the edit boxes where you enter a range for a chart element. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "rolando" wrote in message ... I have 1 serie with 20 datapoints, defined as line-type graph A 2nd series represent the average of all 20 datapoints an is located at position 20 on the X-axis, defined as scatter-type I want to draw a line from this point towards the Y-axis, to mark the average. For this I use the X-error bar with a fixed value of 19; 20 cannot be used because the Y axis would shift 1 tick mark to the right (?) The number of datapoints is growing (here 20) and is located in a particular cell. Can I use this ref as custom error bar value but minus 1 so I don't have to change the value every time the number of datapoints is increasing ? |
Thread Tools | |
Display Modes | |
|
|