Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,


    I work a lot with data visualisatio, facing a lot of anoying questions like now.
    Is it possible to anchor some shapes, according to another shape?????
    As You can see in the attached workbook, I need to anchor some datashapes, corresponding to its regional district.
    As an example, Im using the districts of my hometown Vienna, where I want to center some datashapes into it. I got an
    UDF to size the datashapes -> what I need is, how can I size and anchor the datashapes for the districts???
    I am still fighting as well with the use of the names to get them not hardcoded in the UDF.
    any help is welcome...

    stefan
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There's no way to anchor one shape to another in Excel, so you'll have to do it all in code: calculate the top and left coordinate of each circle so that it is centred on the corresponding map shape.

    If you have to do this a lot, you may want to invest in a product such as Microsoft MapPoint - Europe.


  3. #3
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    well, I know this but I still want to avoid it.
    So I can set the coordinate like I hav shown in a former spreadsheet (conditional colouring...).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •