It’s now half time for our NFL Drive Chart tutorial and so I thought I’d share another Popcorn Chart with you.
This one is a Chess Game Viewer and it’s a lot easier to construct:
The image above is a screen shot of the Excel 2007 Chess Game Viewer. The workbook is another implementation of the Popcorn Chart as series pop off the screen as chess pieces are captured.
If you’ve been reading my blog you know that I try to avoid IF() functions whenever possible. See I Heart IF for details. Previously I shared about using boolean expressions as one method to eliminate many IF() functions. The way this is usually done works well with numeric formula results. The Chess Game Viewer demonstrates a technique to do the same with formulas that result in text output. The key is the REPT function, which does not error out with zero repetitions.
The project demonstrates conditional chart formatting without VBA and using images as marker fill.
It showcases the advantage of using a state machine as input to the dynamic chart. This gives us the ability to view a game forward and backwards.
The Chess Game Viewer uses one compound chart comprised of a Stacked Column chart type for the chessboard and an XY (Scatter) chart type for the chess pieces.
The chart sheet is protected but there is no password. So to dig into the working details, just Unprotect the sheet.
You can find the controls to advance the game and to change the chessboard style at the bottom right corner of the chessboard.
I’d love to hear your feedback.
Here’s the Excel 2007 workbook.
— UPDATE —
Okay, I’ve been getting a lot of requests to provide a copy of the chess viewer that will work in previous versions of Excel. Today, I made one, but it looks terrible. Excel 2007’s graphics capability are far superior. At any rate, at least it works. Here it is…