Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Chart Size
Hi, I would like to create multiple charts by VBA. However, the chart
size were difference in different resolution's computers. May I know how to make all charts have Width=10cells x Height = 15cells under different resolution's computers? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Chart Size
You can set the chartobject's Width and Height to the Width and Height of a 10x15 range on the worksheet. However, this assumes all users have the same cell "sizes" '**************** dim rng as range set rng=range(activesheet.cells(1,1), activesheet.cells(15,10)) with oChart .width = rng.width .height = rng.height end with '***************** Adjust to suit. Tim wrote in message ... Hi, I would like to create multiple charts by VBA. However, the chart size were difference in different resolution's computers. May I know how to make all charts have Width=10cells x Height = 15cells under different resolution's computers? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a ' } ' into excel so that I can adjust its size? | Excel Discussion (Misc queries) | |||
adjust automatically size margins | Excel Discussion (Misc queries) | |||
Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
How would I adjust size for printing | Excel Discussion (Misc queries) | |||
adjust range size?? | Excel Programming |