Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
error when resizing chartarea programaticly
sThis snipet of code fails in the with black while trying to set .width = 200
sub a() Set co = ActiveSheet.ChartObjects.Add(cw * 3, rh * 0.5, cw * 8, rh * 20) ' Name it co.Name = "ChartExample" With co.Chart.ChartArea .Width = 200 End With end sub |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
error when resizing chartarea programaticly
You can't change the chart area of an embedded chart; it is defined by the
width of the chart object. Try this: co.Width = 205 You need to make the chart object a few points wider (~ 205 I'm guessing) than the chart area (200) of the chart it contains. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TONY" wrote in message ... sThis snipet of code fails in the with black while trying to set .width = 200 sub a() Set co = ActiveSheet.ChartObjects.Add(cw * 3, rh * 0.5, cw * 8, rh * 20) ' Name it co.Name = "ChartExample" With co.Chart.ChartArea .Width = 200 End With end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing the legend | Charts and Charting in Excel | |||
Resizing a sheet | Excel Discussion (Misc queries) | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
What is the relationship between .ChartArea and the default printer ? | Charts and Charting in Excel | |||
chartarea | Charts and Charting in Excel |