• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Understanding Excel Worksheet... > Making Data Graphical with Charts

Making Data Graphical with Charts

When most people look at a page of numbers, they see abstract values. To give that data meaning and make it more understandable, Excel provides tools for charting (graphing) the data. Charts provide a way to transform your data into a picture that more effectively illustrates the significance of the data. For example, a bar chart is commonly used to illustrate how profits have increased or decreased over time. A nonprofit organization might use a pie chart to illustrate how much money is allocated to each of its various programs. Or you might use a line chart to examine how your investments have performed over the past 12 months.

Excel features a wide selection of chart types to help display data in various ways. The type you choose depends on the data you are charting and how you want that data presented. Table 1.1 lists Excel’s chart types, along with a description of each type. Figure 1.12 shows the most common chart types in action.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint