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 !

In my experience, when you have a stand-alone chart sheet like that, the
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 the
above mentioned dialog, there are options that will partially unlink
the size of the chart area from the printing area.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=496033