Excel 2007
Excel 2007 removes the ability to record me moving creating and moving rectangles.
Does someone know the code/properties/objects required to create a Rectangle, and change its height, width, position and text ?
I'm looking to create rectangles to give a visual representation of percentages, so for example :
(assuming the complete width is 30cm)
10% 20% 70% would be 3 rectangles (1x3) (1x6) (1x21)
10% 30% 40% 20% would be 4 rectangles (1x3) (1x9) (1x12) (1x6)
Any ideas ?
Excel 2007 removes the ability to record me moving creating and moving rectangles.
Does someone know the code/properties/objects required to create a Rectangle, and change its height, width, position and text ?
I'm looking to create rectangles to give a visual representation of percentages, so for example :
(assuming the complete width is 30cm)
10% 20% 70% would be 3 rectangles (1x3) (1x6) (1x21)
10% 30% 40% 20% would be 4 rectangles (1x3) (1x9) (1x12) (1x6)
Any ideas ?
