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 …

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 …

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.

Create a Map chart in Excel to display geographic data by value or category. Map charts are compatible with Geography data types to customize your results.

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 …

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 …

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 …

Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot in a bubble chart. To copy the example worksheet data Create a …

Create a waterfall chart Select your data. Select Insert > Insert Waterfall ... > Waterfall. You can also use the All Charts tab in Recommended Charts to create a waterfall chart.

When you create a single-series chart, all data markers that represent the data points in that data series are displayed in the same color. To use different colors for each data marker, you can …