Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 and chart as chartsheet
I have code that moves a new chart from its worksheet to a chartsheet and
changes its orientation to portrait. The resulting chart only fills about two thirds of the page. There is a big blank area at the bottom. I can manually change the plotarea to make it fill the entire page, but I can not do so via any VBA statement I have tried. And of course the recorder doesn't record htis action! Can anyone suggest a cure (other than Excel 2003 <grin) Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Bar Chart to line chart excel 2007 | Charts and Charting in Excel | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
Is it possible to hyperlink from a worksheet to a chartsheet? | Charts and Charting in Excel | |||
1 ChartSheet, 10 worksheets | Charts and Charting in Excel |