Standard Range | search
Click here to view Standard Range news from 60+ newspapers.
Bookmark or Share- Create a Pareto chart - Microsoft SupportClick Insert > Insert Statistic Chart, and then under Histogram, pick Pareto. You can also use the All Charts tab in Recommended Charts to create a Pareto chart (click Insert > Recommended Charts > All Charts tab. Tip: Use the Design and Format tabs to customize the look of your chart.
- Add, change, or remove error bars in a chart - Microsoft SupportError bars in charts you create can help you see margins of error and standard deviations at a glance. They can be shown on all data points or data markers in a data series as a standard error amount, a percentage, or a standard deviation.
- Create a box and whisker chart - Microsoft SupportUse 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.
- Change axis labels in a chart - Microsoft SupportRight-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.
- Create a waterfall chart - Microsoft SupportCreate a sunburst chart in Office. Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
More
