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.

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 …

Learn how to create a chart in Excel with recommended charts. Excel can analyze your data and make chart suggestions for you.

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.

Try creating charts with prompts like: Create a chart from this table that has vendor budget on the X axis and headcount on the Y axis. Use 10,000 as the baseline. Create a line chart showing …

Try it! Add a line chart right on an Access form. Select Create > Form Design. Select Insert Chart > Line > Line. Click on the Form Design grid in the location where you want to place the chart. …

Create a Pareto chart Select your data. Typically, you select a column containing text (categories) and one of numbers. A Pareto chart then groups the same categories and sums the …

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 …

Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.

Create sparklines Select the data range for the sparklines. On the Insert tab, click Sparklines, and then click the kind of sparkline that you want. In the Insert Sparklines dialog box, notice that …