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.

Download this sample workbook to follow along with the article: python-in-excel-iris-dataset.xlsx. Create a pair plot with seaborn This example shows how to create a pair plot visualization of …

While Excel 2013 doesn't have a chart template for box plot, you can create box plots by doing the following steps: Calculate quartile values from the source data set. Calculate quartile …

Learn about the differences between scatter and line charts The main difference between scatter and line charts is the way they plot data on the horizontal axis. For example, when you use 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 …

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

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 …

Create a box and whisker chart Select your data—either a single data series, or multiple data series. (The data shown in the following illustration is a portion of the data used to create the …

Change the way that data is plotted How Excel determines how data is plotted in a chart When you create a chart, Microsoft Office Excel determines the axis on which the data series are …

The following examples show Excel’s behavior with each of these options. Options for showing empty cells Options for cells with #N/A Change the way that empty cells, null (#N/A) values, …