Hi,

Assuming data is laid out in range A1:D6, where A2:A6 contains question
text, B2:B6 average scores.
C2:C6 Max scores and D2:D6 Min scores. B1:D1 contain series names.

Create a clustered column chart on the range A1:D6
Select the Average scores series and move to the secondary axis. Format
Axis Secondary.
Delete the secondary Y axis so the series uses the main Y axis for it's
scaling.
Select the Max Score series and format overlap and gap width to 100. Format
Series Options ...
Select the Min Score series and format the border to none and the Pattern to
that of the plot area. Format Patterns ...

You should now have an area behind each average score column showing the min
to max score.

You might want to change the Average scores chart type to a line chart with
Markers Only.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mark Winter" <Mark wrote in message
...
I am a management consultant with basic Excel 2003 experience.

I want to create a dashboard for a client, which is going to be a column
graph displaying the average scores (max score of 5) for 6 questions. The
questions are assessing a relationship between two teams.

I want to add in an indicator to show the maximum score and the minimum
score for each question - I would call this the range, but I know Excel
has
its own terminology. Can this be done? It would allow me to show if the
answers are polarised e.g: some people are very happy, some are very
unhappy.

I have spent much time reading and searching, I know this is basic but the
help would be very appreciated!