Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
timg
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression - Standard Error X Variable 1 Claude S Excel Worksheet Functions 2 November 19th 05 10:08 AM
object variable or with block variable not set Diego Excel Discussion (Misc queries) 1 August 9th 05 02:46 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM
I Need VBA Assistance for global variable question Brent E Excel Discussion (Misc queries) 1 March 1st 05 08:46 PM
"Drawing" Toolbar is inactive Deauxx Excel Discussion (Misc queries) 1 December 8th 04 03:03 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"