Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error when using Yield in Excel 2007 VBA | Excel Worksheet Functions | |||
Error with sum formula in excel 2007 | Excel Worksheet Functions | |||
Error in Excel 2007 | Excel Discussion (Misc queries) | |||
Error message in Excel 2007 | Excel Discussion (Misc queries) | |||
Custom Error Bar for Excel 2007 | Excel Discussion (Misc queries) |