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

Chapter 13. Lookup and Reference Functio... > Auto Update Charts Using the OFFSET ...

Auto Update Charts Using the OFFSET Function

Do you ever have to update data on a regular basis and then change the chart information to match the new data? There’s a couple of ways you can automatically update charts from updated data—one is with plot visible cells only, and the other is by using a more efficient solution with the OFFSET function and NAMED ranges (see Figure 13.12). In Figure 13.12 the Date range starts at A2 and the Traffic range starts at B2. To create an auto update chart follow these steps:

Figure 13.12. Use the OFFSET function with NAMED ranges to create an auto-updating chart.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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