- 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 chart types plots data along the horizontal axis (also known as the x-axis) and the vertical axis (also known as the y-axis) is very different
- 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 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
- 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
- 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 three data series that each contain a set of values
- 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-scale) axis You can also manually change a category axis to a date axis A date axis displays dates in chronological order at specific intervals or base units, such as the number of days, months
- 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 usual square data markers
- Choosing the best trendline for your data - Microsoft Support
When you want to add a trendline to a chart in Microsoft Graph, you can choose any of the six different trend regression types The type of data you have determines the type of trendline you should use Trendline reliability A trendline is most reliable when its R-squared value is at or near 1 When you fit a trendline to your data, Graph automatically calculates its R-squared value If you
|