In a scatter chart, the daily rainfall values from column A are displayed as x values on the horizontal (x) axis, and the particulate values from column B are displayed as values on the vertical (y) axis. Often referred to as an xy chart, a scatter …

With two values, you get a scatter chart of little circles, all the same size. With three values, you get bubble chart. Each bubble is a different color and the size of the bubble illustrates the third value. To convert the table to a chart, on the Design tab: In Power View in Excel, click the arrow under Other Chart and click Scatter.

Scatter charts show numeric coordinates along the horizontal (X) and vertical (Y) axes. Use a scatter chart when you want to find out how much one variable is affected by another. For example, plot the salary of employees and years of experience.

In a line, scatter, or radar chart, do one of the following: To select all data markers in a data series, click one of the data markers. To select a single data marker, click that data marker two times. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click Format ...

In the chart, select the data series that you want to add a trendline to, and then click the Chart Design tab. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. On the Chart …

Click Chart on the Insert menu. In the Chart Wizard - Step 1 of 4 - Chart Type dialog box, click the Standard Types tab. Under Chart type, click XY (Scatter), and then click Next. In the Chart Wizard - Step 2 of 4 - Chart Source Data dialog box, click the Data Range tab.

Add up/down bars. In the chart, select the data series that you want to add up/down bars to. On the Chart Design tab, click Add Chart Element, point to Up/Down Bars, and then click Up/down Bars.

In the chart, click the horizontal axis, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. This displays the Chart Tools, adding the Design and Format tabs. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the horizontal (category) axis.

A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data. Consider using a scatter chart ...

Chart that uses a date axis. In the chart, right-click the category axis, and then click Format Axis. In the Format Axis pane, select the Axis Options tab. Expand Axis Options, and then under Axis Type, make sure Date axis is selected. Under Units, next to Base, select Days, Months, or Years.