ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adding formula to the boxes of organization chart (https://www.excelbanter.com/excel-programming/427188-adding-formula-boxes-organization-chart.html)

thread

adding formula to the boxes of organization chart
 
hi all,
is it posible to have formulas in the organization chart?
i'm trying to have an option to calculate number of people depending
on propability
the chart will indicate the propability multiply by the x factor
any ideas?

thread

adding formula to the boxes of organization chart
 
ok i found a solution,the idea is to choose the text box and add the
formula to the cell and this is how it can work


On 20 אפריל, 12:43, thread wrote:
hi all,
is it posible to have formulas in the organization chart?
i'm trying to have an option to calculate number of people depending
on propability
the chart will indicate the propability multiply by the x factor
any ideas?



thread

adding formula to the boxes of organization chart
 
what i meant here is that i would like to have a formula inside of a
text box(that direct for a cell in the excel)

for example
i will put propability 0.6 and 0.4
i would like to see 60 in the organization

On 20 אפריל, 12:43, thread wrote:
hi all,
is it posible to have formulas in the organization chart?
i'm trying to have an option to calculate number of people depending
on propability
the chart will indicate the propability multiply by the x factor
any ideas?




All times are GMT +1. The time now is 10:45 AM.

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