Microsoft Office Tutorials and References
In Depth Information
Figure 17-33: This application uses a variety of techniques (but no VBA code) to plot monthly climate data for
two selected U.S. cities.
The key to this application is that the chart uses data in a specific range. The data in this range is retrieved from
the appropriate data table by using formulas that use the VLOOKUP function.
The formula in cell A23, which looks up data based on the contents of City1, is
=VLOOKUP(City1,INDIRECT(DataTable),COLUMN(),FALSE)
The formula in cell A24 is the same except that it looks up data based on the contents of City2:
=VLOOKUP(City2,INDIRECT(DataTable),COLUMN(),FALSE)
After entering these formulas, I simply copied them across to the next 12 columns.
Search JabSto ::




Custom Search