Plethora of Newbie Questions: How to Cross Reference Shape DataAcross Shapes?

[SteveM]

I have three Geo-Shapes on a page each with the same shape data types
I add a Pie Chart to the page from the Charting Shapes stencil
I want to populate the Pie Chart Shape Data Rows with data from the
three Geo-Shapes.
But I for the life of me, cannot figure out the process for inserting
the Geo-Shape data into the Pie Chart data rows.
I can fat finger it.
I can VBA code it
But is there any way for me to copy an entire Geo-Shape data formula
as a reference (Shape, Row, Cell) and paste it into the Pie Shape row?

I'd love to know this as a general technique (if there is one.)

Thanks Much,

SteveM

P.S. Pardon my slog through the morass...

 

[Paul Herber]

I have three Geo-Shapes on a page each with the same shape data types
I add a Pie Chart to the page from the Charting Shapes stencil
I want to populate the Pie Chart Shape Data Rows with data from the
three Geo-Shapes.
But I for the life of me, cannot figure out the process for inserting
the Geo-Shape data into the Pie Chart data rows.
I can fat finger it.
I can VBA code it
But is there any way for me to copy an entire Geo-Shape data formula
as a reference (Shape, Row, Cell) and paste it into the Pie Shape row?

I'd love to know this as a general technique (if there is one.)

I've put up a file
http://www.sandrila.co.uk/sizeOfShapeChangingPieSliceSize.zip
which contains sizeOfShapeChangingPieSliceSize.vsd

Changing the width of the rectangle will modify the pie slice size.
This shows how to reference a cell from another shape. How you control
the ranging and keeping the total to 100% is outside the scope of my
example!