Instead, take advantage of one of Excel's more hidden options, transposition, which automatically flips Excel data into horizontal position. You control which cells are included and where they appear.

XY Scatter to Edit Horizontal Data in Excel 2007. ... adds new labels to the x-axis and plots new data points on the chart. ... color, outline and effects of the horizontal axis line and data labels.