title: Extend horizontal line to edges of chart area
body: <p>In Excel 2007 I have a chart with a horizontal line (data series) similiar to what <a href="http://www.extendoffice.com/documents/excel/1265-excel-add-average-line-to-chart.html" rel="nofollow">this page</a> shows. But, as you notice, the line starts and ends in the middle of the data point. So, if there are bars on the same chart, the horizontal line will not extend to cover the entire first and last bars. How can I extend the horizontal line to touch the chart edges on the left and right sides?</p>
  
  <p>I tried putting in "dummy" points at the beginning and end of the data series that had zero values (for the bars). This looked good, but the x-axis numbering started at zero and ended at one more than my last real data point, which, in my case is unacceptable.</p>
  
  <p>Oh, and I'm creating the charts in VBA, so I need a VBA solution (which may be the same as the manual solution, just coded). Thanks.</p>