Microsoft Office Forums Org chart depth limited to 46 shapes

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2019, 07:40 AM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default Org chart depth limited to 46 shapes


It seems that the Visio Org chart has a depth limit of around 46 shapes. I am trying to use it to create test scripts, but am limited by this to scripts with 22 steps or fewer (One shape for test step, another for result).
Is this correct, and can it be increased?
Reply With Quote
  #2  
Old 11-06-2019, 05:15 PM
Guessed's Avatar
Guessed Guessed is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,357
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

I haven't seen this limit and have created WBS trees (which look the same as org charts) with hundreds of shapes. Those graphics don't make chains as complex as 46 levels though.

Is this really a process flow you are talking about or an Org Chart? Can you describe the steps you are making to run into the limitation you are finding?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 11-06-2019, 10:43 PM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default Org chart depth

Thanks for replying. The restriction is the number of levels, not the number of shapes in the chart. I am building a tree structure with each branch being a test cases. Several test cases may start the same, but branch out lower down, when different conditions are tested.
Reply With Quote
  #4  
Old 11-07-2019, 08:49 PM
Guessed's Avatar
Guessed Guessed is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,357
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Are you using a wizard to do your graphic build or are you using a vba macro?

If you can provide an example table of data I can do some testing to see whether a macro has the same limitations.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 11-07-2019, 10:36 PM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default Org chart depth limit

HI, I am using VBA. Even when I try and amend the chart manually, it doesn't work properly.
Thanks
Neil
Reply With Quote
  #6  
Old 11-08-2019, 03:50 AM
Guessed's Avatar
Guessed Guessed is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,357
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

What version of Visio are you using? I've got Visio Standard 2016 Build 1910 and don't have the same problem with the Org Chart template.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 11-08-2019, 05:41 AM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default

It is the one installed at the office, which is Visio standard 13. I don't have permission to upgrade. Maybe it has been fixed since.
Cheers
Neil


BTW I have a cousin in Canberra - I think that's where you are
Reply With Quote
  #8  
Old 11-08-2019, 09:42 PM
Guessed's Avatar
Guessed Guessed is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,357
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Yes, I'm often in Canberra for work but live in Melbourne.

Have you tried using shapes other than the Org Chart shapes? If you are using vba to build it then you could just as easily choose a flowchart shape which might behave differently.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #9  
Old 11-09-2019, 12:53 AM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default

There is too much code to rewrite. And I am not sure whether other shapes will work properly on an org chart.I still need the org chart functionality to work for editing the resulting chart.


I am uploading test scripts from Excel. These are either created directly from the requirements, or by importing existing scripts.



Anyway, I think it is not related to the shape type.

Thanks.
Neil
Reply With Quote
  #10  
Old 11-09-2019, 02:28 AM
Guessed's Avatar
Guessed Guessed is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,357
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

OK, perhaps you might want to show me the code you are using. It shouldn't be difficult to change shape masters. For instance, in this code extract the choice of shape master is on one line.
Code:
  With appVisio
    If .Documents.Count > 0 And Not bNewDoc Then
      Set aDoc = .ActiveDocument
      Set aPage = aDoc.Pages.Add
    Else
      Set aDoc = .Documents.Add(Filename:=sTemplatePath & sVisioTemplate)
      Set aPage = .ActivePage
    End If
    Set aDocStencil = GetDocStencil(appVisio, sStencil, sStencilPath)      'Load Stencil
    
    'Clear page for new shapes to be added
    Do While aPage.Shapes.Count > 0
      aPage.Shapes(1).Delete
    Loop
    aPage.AutoSize = False
    Set aMast = aDocStencil.Masters(sMaster)
    On Error Resume Next
    For Each aRow In loWBS.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
      Debug.Print Trim(aRow.Cells(1).Value)
      lRow = lRow + 1
      lLeftStep = aRow.Cells(3).Value
      If lRow > 1 Then sParent = Trim(aRow.Cells(4).Value)
      If bJoin And sParent <> "" Then
        Set aShp = aPage.DropConnected(aMast, aPage.Shapes("WBS_" & sParent), 2)    'visAutoConnectDirDown=2
      Else
        lPosY = lPosY - lPrevShapeHeight - dblSpacing
        Set aShp = aPage.Drop(aMast, 1 + lLeftStep / 2, lPosY)    ' 10 - lRow / 3
        lPrevShapeHeight = aShp.CellsU("Height")
      End If
      aShp.Name = "WBS_" & Trim(aRow.Cells(1).Value)
      For i = LBound(arrProps) To UBound(arrProps)
        sProp = "Prop." & arrProps(i)
        aShp.CellsU(sProp).FormulaU = Chr(34) & Trim(aRow.Cells(i + 1).Value) & Chr(34)
      Next
    Next aRow
This code extract is more complicated than necessary because it includes an option to link child graphics or place them in an indented tree structure without a link depending on a choice the user made earlier.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #11  
Old 11-09-2019, 03:00 AM
Pavane Pavane is offline Org chart depth limited to 46 shapes Windows 10 Org chart depth limited to 46 shapes Office 2013
Novice
Org chart depth limited to 46 shapes
 
Join Date: Nov 2019
Location: Wales, UK
Posts: 6
Pavane is on a distinguished road
Default

Thanks Andrew, but I am straying too far from the problem.
I will just live with the restriction - maybe someone in Microsoft will accept that it exists.

My code base is too big to meddle with. I already break things when I try improvements
Regards
Neil
Reply With Quote
Reply

Tags
limitations, org chart

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to add shapes to Smart Art Org Chart R Mohan PowerPoint 4 06-18-2018 12:43 PM
PPT 2010 - Animated Chart by Series - Animations reset when editing chart agaudet21 PowerPoint 0 10-12-2017 06:18 AM
Org chart depth limited to 46 shapes Powerpoint | animation | depth management aGrumpyKoala PowerPoint 3 08-19-2016 05:43 AM
Org chart depth limited to 46 shapes MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table billcary Project 3 09-22-2014 07:10 AM
Org chart depth limited to 46 shapes Field Size Limited to 255 RzB Mail Merge 1 11-30-2011 04:51 AM


All times are GMT -7. The time now is 07:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft