Microsoft Office Tutorials and References
In Depth Information
Changing a chart’s data source
Displaying data graphically
When you enter data into a Microsoft Excel worksheet, you
create a record of important events, whether they are
individual product sales, sales for an hour of a day, or the price
of a product. However, a list of values in cells can’t easily
communicate the overall trends in your data. The best way
to communicate trends in large data collections is through
charts and graphs, which summarize data visually.
Table 12-1 Standard Excel chart types and uses
Compares categories of data in vertical format.
Compares categories of data in horizontal format.
Displays trends in data over time.
Compares data as part of a contribution to a
As an example of how charts and graphs can help present
your data more effectively, consider the following Excel table,
which lists the number of transactions generated by a small
Compares pairs of values in a dot format.
Compares the trend of values over time or
When you present the results in a chart or graph, as in a line
chart, you can compare the values more readily. The
following table explains which types of data each chart type can be
used to represent effectively, but feel free to experiment!
Compares multiple series of data in a percent
Displays changes in values relative to a center
Displays trends in values across two dimensions.
Compares sets of three values.
Displays a chart to compare stock prices.
Same as a column or bar chart, but a cylinder is
Same as a column or bar chart, but a cone is used.
Same as a column or bar chart, but a pyramid is
Combines two types of charts into a single chart.