The project requires a Visio 2007 advanced data graphic that links an excel spreadsheet to Visio to display a complex data graphic. The data graphic has:
- A single inner square with a header text (this is the key)
- Around the outside there are 51 objects that need to either be visible (if there is a value) or blank if there is no value. Each subsequent row in the Excel file will use the same 51 objects and they need to remain in the same order.
- Each of the 51 objects needs another object that is a circle with four quadrants. Each quadrant can have one of four colours, depending on the value in the spreadsheet. These circles need to always be placed next to the correct object.
This is an immediate requirement and is to create the data graphic object. No population of the object will be required.