Appendix D. Spreadsheet Tips
These Spreadsheet Tips complement the Spreadsheet Solutions that appear throughout this book. Use these tips about creating charts and using work-sheet statistical functions as a starting point to learn more about how to use Microsoft Excel to obtain your own customized results.
CT: Chart Tips
CT1 Arranging Data in Categorical Charts
You can sort your data to display categories in largest to smallest order. For bar charts, arrange the summary table in largest to smallest order. For pie charts, arrange the summary table in largest to smallest order in order to show largest to smallest pie slices in clockwise order.
CT2 Reformatting Charts
Right-click on chart components to reformat chart components. Use this technique ...
Get Even You Can Learn Statistics and Analytics: An Easy to Understand Guide to Statistics and Analytics, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
