A Challenge: how to create this chart in MS Office?

[devang29]

Hi,

For an employee presentation, i need to create a chart like the one attached. It's terribly hard to create it in PowerPoint, Excel, etc.

The rating scale works with 1 being the best and 5 being the worst. so the max has to be 1 and the minimum has to be 5 which Excel does not accept.

Then, there has to be a line (such as the mean which in this case is 3) relative to which the other values are plotted.

How do i create such a chart?

thanks a million,
devang