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 …

Set varying colors of data markers (bars, columns, lines, pie or doughnut slices, dots, and other shapes) automatically in an Office chart.

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 …

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 …

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 …

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.

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 …

Jan 12, 2013 · 15 I'm charting daily values using a line chart. On some dates, I don't have any data. I would like the chart to connect the data points for which I have data across any gap in …

Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.