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 …

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.

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.

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.

Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult …

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 …

Describes an issue where the lines of a Line chart may plot with gaps when the data range of the chart contains blank cells in Microsoft Excel.

By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet …

You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the …

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