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

Chapter 10. Creating a Chart > Editing Datasheets

Editing Datasheets

A chart is only as good as the data itcontains. You can't adjust the height of bars or the size of the pieces of pie in a pie chart by clicking them; instead, you have to alter the data that is being used to create the chart. To do that, you use the datasheet, which opens automatically when you create a chart. You can also access it whenever you have a chart selected by choosing View, Datasheet (choosing it again will close it) or clicking the View Datasheet button on the Charting toolbar.

What is a Datasheet?

A datasheet (see Figure 10.21) looks a little like a spreadsheet. Information is entered in cells, which are formed by the intersection of rows and columns. For most types of charts—with the exceptions noted in the list of standard chart types I provided earlier—each column represents a category of data, while each row is a data series, and is marked with a symbol—for example, a small 3-D bar—to indicate what type of chart you're creating.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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