Present your data in a scatter chart or a line chart Scatter charts and line charts look very similar, especially when a scatter chart is displayed with connecting lines. However, the way each of these …

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 instead of the …

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 your data has …

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 and sepal_width …

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

When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date (time …

In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all the data …

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 Show #N/A as …

When you create a single-series chart, all data markers that represent the data points in that data series are displayed in the same color. To use different colors for each data marker, you can vary the colors …

Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.