Select the Insert tab, and then select X Y Scatter, and under Scatter, pick a chart. With the chart selected, select the Chart Design tab to do any of the following: Select Add Chart Element to modify details like the title, labels, and the legend. Select Quick Layout to choose from predefined sets of chart elements.

Create a scatter plot with Matplotlib This example describes how to create a scatter plot with the Iris flower sample data set. A scatter plot shows the relationship between two numerical variables in a data set. The example creates a scatter plot that looks like the following screenshot, comparing the sepal_width and sepal_length values.

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 ...

Scatter and bubble charts are a great way to display a lot of related data in one chart. In scatter charts, the x-axis displays one numeric field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the chart. In a bubble chart, a third numeric field controls the size of the data ...

A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Just like a scatter chart, a bubble chart does not use a category …

Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past!

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.

To make the data in a chart easier to read, you can display horizontal and vertical chart gridlines that extend across the plot area of the chart. You can also display depth gridlines in 3-D charts. Gridlines can be displayed for major and minor units, and they align with major and minor tick marks on the axes when those are displayed.

In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart).

Learn more about axes. Charts typically have two axes that are used to measure and categorize data: a vertical axis (also known as value axis or y axis), and a horizontal axis (also known as category axis or x axis). 3-D column, 3-D cone, or 3-D pyramid charts have a third axis, the depth axis (also known as series axis or z axis), so that data can be plotted along the depth of a chart.