How Do You Create A Scatter Chart?
Scatter charts are typically used to showing and analyze numerical values from a table of data. Microsoft Excel features, among other chart types, built-in scatter chart capabilities. Scatter charts are often mistaken for line charts. Line charts display category data equally along the x-axis, and value data equally along the y-axis. Scatter charts combine two sets of numerical data to form uneven clusters, or scatters, of data. Open the Excel workbook of data you want to analyze. Rearrange your table of data. The first row (or column) will be the x-axis values, and the second row (or column) the y axis-values. Click “Scatter” in the “Charts” tab of the main “Insert” toolbar. Click “Scatter with only markers.” Click the chart to bring up the options for the chart, from here you can amend the color of the chart, the formatting, fonts or titles. Open the Excel workbook of data you want to analyze. Rearrange your table of data. The first row (or column) will be the x-axis values, and the
