Interactive Chart With No Macros
A companion file is available: Click here to download
This tip presents a highly interactive workbook, without a single macro. The workbook allows you to select two U.S. cities, and then displays a comparison chart for the following variables.
- Percent Sunshine
You can download the workbook and examine how it's done. Hint: It's done with named ranges and worksheet controls.
Search for Tips
Browse Tips by Category
Needs tips? Here are two books, with nothing but tips:
Contains more than 200 useful tips and tricks for Excel 2007 | Other Excel 2007 books | Amazon link: John Walkenbach's Favorite Excel 2007 Tips & Tricks