Highline Excel 2013 Class Video 46

Statistics: Histogram Formulas & Chart in Excel 2013

DESCRIPTION

Topics in this video:
1. Formulas for Min and Max values
2. Formulas for Chart Labels
3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria.
4. Histogram Chart with No Gap Width and Labels linked to cells
5. Change Formulas for Chart Labels with the CHAR(10) formula element to add wrap Text (Line Return) in the formula so that all category labels wrap to three lines

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 221 times – 21 MB




Be the first to comment

Leave a Reply