Full width lines on bar charts

[MrPez]

I've got some bar charts that have reference levels displayed as lines over the bars. Problem is they don't go the whole width of the chart and so for charts that only have a couple of entries they look a bit funny! See attachment.
Any suggestions?

[Andy Pope]

Move the line to the secondary axis, add secondary horizontal axis and set Min=1 Max=2

Here are various ways of adding a datum line
http://www.andypope.info/charts/averageline.htm