Ajusting a ChartArea's size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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, 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
 
Back
Top