Create a box and whisker chart - Microsoft Support
Use the new box and whisker chart in Office 2016 to quickly see a graphical representation of the distribution of numerical data through their quartiles. Box and whisker charts are often used in statistical analysis.
Available chart types in Office - Microsoft Support
Choose a new chart type in the Change Chart Type box. Many chart types are available to help you display data in ways that are meaningful to your audience. Here are some examples of the most common chart types and how they can be used.
Change the plotting order of categories, values, or data series
To change the plotting order of values, click the vertical (value) axis. Click a chart. This displays the Chart Tools. Under Chart Tools, on the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.
Create plots and charts with Python in Excel - Microsoft Support
Python in Excel comes with a core set of Python libraries provided by Anaconda. This article describes how to use Python libraries, such as seabornand Matplotlib, to create plots and charts. To learn more about the open-source libraries available with Python in Excel, see Open-source libraries and Python in Excel.
Create a box and whisker chart - Microsoft Support
Use the new box and whisker chart in Office 2016 to quickly see a graphical representation of the distribution of numerical data through their quartiles. Box and whisker charts are often used in statistical analysis.
Add, change, or remove error bars in a chart - Microsoft Support
In scatter and bubble charts, you can show error bars for x and y values. Click anywhere in the chart. Click the Chart Elements button next to the chart, and then check the Error Bars box. (Clear the box to remove error bars.) To change the error amount shown, click the arrow next to Error Bars, and then pick an option.
Change the scale of the vertical (value) axis in a chart
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 your needs.
Create a box and whisker chart - Microsoft Support
Use the new box and whisker chart in Office 2016 to quickly see a graphical representation of the distribution of numerical data through their quartiles. Box and whisker charts are often used in statistical analysis.
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.
Present your data in a scatter chart or a line chart - Microsoft …
Click the plot area of the chart, or on the Format tab, in the Chart Elements box, select Plot Area from the list of chart elements. On the Format tab, in the Shape Styles group, click the More button , and then click the effect that you want to use.
Add a legend to a chart - Microsoft Support
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.