Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.

Before you choose either a scatter or line chart type in Office, learn more about the differences and find out when you might choose one over the other.

In addition to the x values and y values that are plotted in a scatter chart, a bubble chart plots x values, y values, and z (size) values. You can use a bubble chart instead of a scatter chart if …

Because the scale of the line chart's horizontal (category) axis cannot be changed as much as the scale of the vertical (value) axis that is used in the xy (scatter) chart, consider using an xy …

In Excel, Outlook, PowerPoint, or Word, for Windows and Mac, you can format (add, change or remove) error bars in a chart.

If you have a line, (xy) scatter, or radar chart, you can change the look of the data markers to make them easier to distinguish. The line in this combination chart shows round data markers …

Create a box and whisker chart Select your data—either a single data series, or multiple data series. (The data shown in the following illustration is a portion of the data used to create the …

To create a scatter plot of the Iris flower data set with the Matplotlib library, take the following steps: In a Python in Excel cell, use the Matplotlib scatter function and enter the sepal_length …

Change the number of categories between labels or tick marks On a chart, click the horizontal (category) axis that you want to change, or do the following to select the axis from a list of …

Note: On a scatter chart that displays only markers (without connecting lines), you can display empty cells as gaps or zero only — you cannot connect the data points with a line. Click the …