Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Drawing Attributes
Hello,
I'd like to be able to link, for example, the diameter of a Drawing Circle to the value contained in a particular cell and have the drawing update accordingly. Similarly, I'd like to be able to do this for a variety of geometries (the length of a line, the separation of circle centers, etc...). In other words I'm looking for the ability to make calculation driven simple drawings. Is this possible? -- Regards, timg. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Drawing Attributes
You may want to look at how Debra Dalgleish made a smiley face:
http://contextures.com/excelfiles.html Look for Happy Face Gauge Right click on the worksheet tab and select view code and you'll see how she incorporates the changes into the picture. timg wrote: Hello, I'd like to be able to link, for example, the diameter of a Drawing Circle to the value contained in a particular cell and have the drawing update accordingly. Similarly, I'd like to be able to do this for a variety of geometries (the length of a line, the separation of circle centers, etc...). In other words I'm looking for the ability to make calculation driven simple drawings. Is this possible? -- Regards, timg. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression - Standard Error X Variable 1 | Excel Worksheet Functions | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) | |||
"Drawing" Toolbar is inactive | Excel Discussion (Misc queries) |