Microsoft Office Tutorials and References
In Depth Information
Section 12: Summarizing data visually using charts
visually using charts 12
Summarizing data
In this section:
Microsoft Excel 2013 gives you lots of ways to change how your
Creating a chart
numeric data is displayed. You can change the color or font of data
you want to emphasize, make your labels bold to set them apart from the
body of data in your worksheets, and add graphics to establish your
corporate identity. You can use totals and subtotals to summarize your data,
making it easier for you and your colleagues to compare values for entire
categories of data.
Changing a chart’s layout, style, and
Formatting chart legends and titles
Adding and removing data labels and
grid lines
Formatting chart axes
The limitation of working with numbers, even in summary, is that it can be
difficult to keep track of several numbers at a time. If you’ve worked for
several years in a package delivery company, you might know that
November and December are the busiest months of the year and that February
and March show the lowest package volume. If you’re presenting results to
colleagues or potential investors who are less familiar with your business,
you can use charts and graphs to summarize your data visually. By
summarizing your data using a chart, you make it much easier for your colleagues
to see patterns and relationships.
Changing a chart’s data source
Adding and deleting data series
Filtering charts
Manipulating pie charts
Creating a stock chart
Adding a trendline to a chart
Summarizing data using sparklines
Formatting and deleting sparklines
Search JabSto ::

Custom Search