I have 24 data values in the range ... C6:C29
I would like some code that would draw 24 rectangles (one for each data value).
The rectangles would have the 3D formatted appearance called ... Intense Effect - Blue, Accent 1
Each rectangle would be 0.5 centimetres wide (vertically).
The length (horizontally) of each rectangle would be the length (in centimetres) found in its corresponding cell.
For example ...
the rectangle for cell C6 would be 0.5cm wide and 1.34cm long ... as cell C6 has the value 1.34 in it.
the rectangle for cell C7 would be 0.5cm wide and 1.02cm long ... as cell C7 has the value 1.02 in it.
I'm guessing these rectangles would need to be all drawn in a new sheet, perhaps called 'Horse Race Rectangles'.
Is this possible ?
Kind regards,
Chris
I would like some code that would draw 24 rectangles (one for each data value).
The rectangles would have the 3D formatted appearance called ... Intense Effect - Blue, Accent 1
Each rectangle would be 0.5 centimetres wide (vertically).
The length (horizontally) of each rectangle would be the length (in centimetres) found in its corresponding cell.
For example ...
the rectangle for cell C6 would be 0.5cm wide and 1.34cm long ... as cell C6 has the value 1.34 in it.
the rectangle for cell C7 would be 0.5cm wide and 1.02cm long ... as cell C7 has the value 1.02 in it.
I'm guessing these rectangles would need to be all drawn in a new sheet, perhaps called 'Horse Race Rectangles'.
Is this possible ?
Kind regards,
Chris