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!