Edit your horizontal chart data in Excel 2007 with a variety of available tools. Change the data, format, titles and scale of your scatterplot's horizontal axis.

Layout 11: Layout 11 shows the following chart elements: Legend (Right), Horizontal Axis, Vertical Axis, and Major Gridlines. Any Layout Style you have chosen is how the layout is going to be.

How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.