Linking Shapes to Cell Values

[ColourfulMoney]

I'm looking for help with taking the values written in cells to pasting them into a shape, like a circle. More specifically, it would need to be bunch of cells (500-1000) shown on one large circle.

As a background, I've written code that determines transient temperatures in a circular cross-section, but would like to display those temperatures in a graphical manner, such as on a circle shaped much like a bulls-eye.

 

[mintjulep]

Public Function grr(gage, value As String)
Worksheets("sheet5").Shapes("display" & gage).TextFrame.Characters.Text = value

End Function

 

[combo]

I'd rather try to use two (grouped) shapes, without vba. The steps:
- add and format backgrount shape,
- select and copy the range with data, select shape, hold SHIFT + Edit>Paste picture link (from menu)
- move copied picture onto background, resize if necessary, group.
As the paste picture link shows a part of sheet as picture, if you format source range, it will be reflected on the picture too.

combo

 

[firefytr]

Have you thought about taking the cell values to a pie chart and displaying values?

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci