Assigning Shapes to Cells

[pbyrne462]

Hoping someone can help.

I have a list of dates and countries and products, for example:

Product X Country X Date X

I have a timeline which I want to represent pictorially so I want to use shapes to show the country, the tricky part is I want that shape to be linked to the date and be positioned on a grid depending on that date.

Is this possible within the boundaries of excel?

Thanks,

Paul

 

[Steve=True]

Yes, you will need to use the camera tool.

Use the camera tool to take a snapshot of a cell that contains your shape.

That shapes cell reference can be controled by a cell.

These links explains what i mean:
http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/
http://chandoo.org/wp/2009/07/13/product-catalogs/
http://chandoo.org/wp/2010/10/19/how-to-use-picture-links/