A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Possible for master to display sum of child numeric values?



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 11:29 PM posted to microsoft.public.visio.general
LMW
external usenet poster
 
Posts: 21
Default Possible for master to display sum of child numeric values?

I'm exploring whether Visio could be used in the following fashion. I would
like for a parent shape to display the sum of shape data fields within child
shapes? Is this doable?
  #2  
Old April 26th, 2010, 01:14 PM posted to microsoft.public.visio.general
Paul Herber
external usenet poster
 
Posts: 1,732
Default Possible for master to display sum of child numeric values?

On Fri, 23 Apr 2010 15:29:01 -0700, LMW wrote:

I'm exploring whether Visio could be used in the following fashion. I would
like for a parent shape to display the sum of shape data fields within child
shapes? Is this doable?


Yes, very easy. If you know the name of the two child shapes and the field names, then in
the parent shape enter a formula into a suitable cell, user-defined cells or shape data
cells will do nicely. Something like =Shape1!cellname+Shape2!cellname. You can then
display this cell.

For example: if you have two shapes Sheet1 and Sheet2 then you can create a formula
=Sheet1!User.q + Sheet2!Prop.r


--
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.sandrila.co.uk/visio-electronics/
Electrical for Visio http://www.sandrila.co.uk/visio-electrical/
Electronics Packages for Visio http://www.sandrila.co.uk/visio-electronics-packages/
  #3  
Old April 26th, 2010, 01:46 PM posted to microsoft.public.visio.general
David J Parker [MVP Visio]
external usenet poster
 
Posts: 110
Default Possible for master to display sum of child numeric values?

It most certainly can.
You can use a formula like:
=SUM(Sheet.6!Prop.Cost, Sheet.8!Prop.Cost, Sheet.10!Prop.Cost)
where sheet.n is the NameID of the child shapes.
I'm not sure what you mean by child shapes - are they sub-shapes in a group,
or connected shapes, or within a container.

"LMW" wrote in message
...
I'm exploring whether Visio could be used in the following fashion. I
would
like for a parent shape to display the sum of shape data fields within
child
shapes? Is this doable?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:20 PM.


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