Chess Game Viewer
This is one of the most creative Excel apps I've ever seen. Created by Daniel Ferry, At Excel Hero: Excel 2007 Chess Game Viewer.
It uses no macros. Unprotect the worksheet and try to figure out how it work. Some hints:
- Dynamic Charting with No VBA
- Combination of XY (Scatter) and Stacked Column chart types
- Marker Fill with picture files.
- Conditional Chart Formatting for chessboard style
- No IF() functions. Not even one. REPT() and boolean logic as alternative to IF() INDEX/MATCH
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.
All Topics
Filter by Category
Subscribe
Recent Comments
Other Blogs
2