Excel Chart Data Lines Extending Through The X And Y Axis Microsoft Community
Mohammad – That's one of the data layouts that my Quick Excel XY Chart Utility can handle It's called XXYY and it's 4th from the left in the first row This will not add the axis titles, but by adding all the series, the ustility will save you more timeClick the chart and then Chart Filters Click Select Data In the Select Data Source window, click Edit Switch Series X with Series Y Click OK to accept changes in Edit Series and then click OK one more time Now, the scatter chart looks like a line chart, with years on the Xaxis
