ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Variable Drawing Attributes (https://www.excelbanter.com/excel-discussion-misc-queries/57797-variable-drawing-attributes.html)

timg

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.

Dave Peterson

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


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com