Creating a "Smart" Autoshape

S

Stan

I am using an Excel file to manually display the overall status of
multiple projects. I have defined 6 Phases that is common to all the
projects, each project is a separate row in the spreadsheet and by
stretching a Rectangle Autoshape on each row I can easily give a visual
presentation of each project status. What I would like to do is add a
bit of intelligence to the auto shape - storing 6 separate strings of
text that I can display when double clicking on the status bar for a
given project. The data is static, by this it is simple text, no formulas.

While this is not a normal use for Excel it is simple and easy to share
with others. Any help or suggestions is appreciated.

Stan
 
C

CLR

Hi Stan...........

One thing I did that might be close to what you're after is to create a
single sheet that gives a graphic representation of a complete Tank Farm,
identifying each Tank, and showing it's level of capacity and percent of
fill, using Cell borders and Conditional Formatting to show each tank
"filling" as the percentage went up.............these sorts of "maps" can be
used for Machine layouts/percent capacity, or any number of things.......

hth
Vaya con Dios,
Chuck, CABGx3
 
Top