On 2002-03-13 11:17, Mark W. wrote:
Fiona, I thought of a work around while at lunch using the following data in cells A1:B7...
{"X","Endpoints"
;1,1
;2,#N/A
;3,#N/A
;4,#N/A
;5,#N/A
;6,6}
...The Endpoints formula is...
{=IF(OR(ROW()=MAX(ROW($A$2:$A$7)),ROW()=MIN(ROW($A$2:$A$7))),A2,#N/A)}
...when entered into cell B2 and copied down to B7.
Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula.
This data can be charted as a Line chart with 2 series. Set the line attribute for the 2nd series (Endpoints) to None and format its markers as desired.
This message was edited by Mark W. on 2002-03-13 11:18