
Present your data in a scatter chart or a line chart - Microsoft Support
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 …
Create plots and charts with Python in Excel - Microsoft Support
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 …
Change data markers in a line, scatter, or radar 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 instead of the …
Add, change, or remove error bars in a chart - Microsoft Support
In Excel, Outlook, PowerPoint, or Word, for Windows and Mac, you can format (add, change or remove) error bars in a chart.
Display or change dates on a category axis - Microsoft Support
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 …
Present your data in a bubble chart - Microsoft Support
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 …
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Display empty cells, null (#N/A) values, and hidden worksheet data in a ...
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 …
Change axis labels in a chart - Microsoft Support
Change the text and format of category axis labels and the number format of value axis labels in your chart (graph).
Change how rows and columns of data are plotted in a chart
Change the way that data is plotted How Excel determines how data is plotted in a chart When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based …