Beautiful Excel Extend Line Graph To Edge

Change your chart type to XY Scatter and set the minmax values of the X-axis to correspond to your starting and ending values.

Excel extend line graph to edge. But as you notice the line starts and ends in the middle of the data point. Does anyone know how to overcome this. The line and column combination chart is not bad but the line doesnt extend to the edges of the chart.

Hover over the bottom right corner and click and drag the highlighted area of the table to extend the selection to the column Target. Adding a line to an existing graph requires a few more steps therefore in many situations it would be much faster to create a new combo chart from scratch as explained above. The solution described on my web site but also demonstrated here is to add an XY series to produce the line.

In the chart shown in this example daily sales are plotted in columns and a line shows target sales of 500 per day. In Excel 2013 after clicking Format Date Series go to click Fill Line tab in the Format Data Series pane and then go down to check. Combo charts combine more than one Excel chart type in the same chart.

In Excel 2007 I have a chart with a horizontal line data series similiar to what this page shows. Locate the Forecast section under the Trendline Options. I am using Excel 2013 and for some reason my lines in charts stopped extending all the way to the edges of the plot area and are leaving a small blank area next to the y axis and on the opposite end.

To add or edit the markers on your line right-click the line in your chart and select Format Data Series. Helper that extends area and lines to the left and right plot edges. Here are two ways you can expand the data range for your chart.

Add a Horizontal or Vertical Line to a Column or Line Chart. Double-click the secondary vertical axis or right-click it and choose Format Axis from the context menu. This thread is locked.