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

Adding Data

Excel provides several ways to add data to a chart. We'll look at the simplest methods first.

Figure 26-1 shows an embedded chart that plots data through May 2. This figure also shows a week's worth of data that we haven't yet added to the chart. Notice that, because the plot area is selected, Excel drew two rectangles around the chart's source data. The first rectangle, in column A, outlines the worksheet range that the chart is using for its category-axis labels. The second rectangle, encompassing columns B through E, outlines the four data series. Excel uses purple for the first rectangle and blue for the second, to help you distinguish the two.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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