Ajusting a ChartArea's size

[happyjanezj]

Hi !
Here is my question:
I am adding a graph(line chart) as a new Excel-sheet, and wanting to
enlarge it's size.I think the ChartArea should be set like that:
With ActiveChart.ChartArea
.Width = 800
End With
It might work as the graph is set in a data sheet, but when it was set as a
graph sheet , it doesn't work.
Error message is that "runtime error 1004 ",and it sais that ChartArea
Class's width can't be set and it considered as read-only.
I'm so puzzled and would like you to help me with it.
If my method is wrong, any good ideas?
Thank you very much !

 

[MrShorty]

In my experience, when you have a stand-alone chart sheet like that, th
size of the chart area is tied to the paper size/orientation/margin/etc
settings from the File->Page Setup dialog. In the Chart tab of th
above mentioned dialog, there are options that will partially unlin
the size of the chart area from the printing area