graphs excel 2003

[Julie from Perth]

I have a worksheet with scores - minimum per question, maximum per question and average per question. i want to create a graph with the minimum and maximum(as a vertical line) and the average as a dot on this line. i can manage to create a graph with each total showing as a dot but want the minimum and maximum to be a vertical line. can anyone help?

 

[VoG]

One way might be to plot the minima and maxima as Error Bars - see Error Bars in Excel Charts

 

[Julie from Perth]

I have tried the Error bars but dont seem to be able to get what i need. I cant seem to get one vertical line with line across top and bottom of error bar (e.g bottom line in position of minimum score and top line in position of maximum score)