
Present your data in a scatter chart or a line chart
Know when to use a scatter or line chart Scatter charts are commonly used for displaying and comparing numeric values, such as scientific, statistical, and engineering data. These charts …
Create plots and charts with Python in Excel - Microsoft Support
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 …
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.
Add or remove a secondary axis in a chart in Excel
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 …
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.
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 …
Bubble and scatter charts in Power View - Microsoft Support
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 …
How to use a macro to add labels to data points in an xy scatter …
Explains how to create and use a VBA macro to attach text labels to data points in an xy scatter chart. You can use the same code for a bubble chart.
Display empty cells, null (#N/A) values, and hidden worksheet 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 …
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 …