oleval
01-24-2008, 05:31 AM
Hi All! I need your help to solve two problems:
1. I'd like to have VBA code on setting the width and height of the selected chart. I tried to use the following code, but it caused an error 'Unable to set the Width property of the ChartArea class'. I can't figure out what is wrong with this, should I try other properties?
...
.ChartArea.Width = 200
.ChartArea.Height = 100
...
2. Another problem is with chart's border color. I tried this code
.ChartArea.Border.ColorIndex = RGB(255, 255, 255)
but it appeared it was a wrong way. I'd like to set the border as a transparent one.
Thank you very much in advance!
1. I'd like to have VBA code on setting the width and height of the selected chart. I tried to use the following code, but it caused an error 'Unable to set the Width property of the ChartArea class'. I can't figure out what is wrong with this, should I try other properties?
...
.ChartArea.Width = 200
.ChartArea.Height = 100
...
2. Another problem is with chart's border color. I tried this code
.ChartArea.Border.ColorIndex = RGB(255, 255, 255)
but it appeared it was a wrong way. I'd like to set the border as a transparent one.
Thank you very much in advance!