3
I can create a chart sheet in Microsoft Excel 2010. I wish to resize the chart so that the proportions fill my wide screen. I right-click the chart and select Format Chart Area. Then I select the Size panel, but the controls are grey-out. How do I resize the chart?
ThomasMcLeod
Posted 2013-11-01T22:45:12.480
Reputation: 170
1
@guitarthrower is right, you can't grab and resize the chart area - the chart will automatically size itself to the sheet. You can change the size of the sheet though - in the Page Layout tab, Page Setup section, use the Size dropdown. There are a limited number of options here, which are populated from the sizes provided by your printer driver. (If you go to Print, select a different printer, and go back to the sheet, you'll see that the selection of paper sizes will change.)
This is pretty frustrating when you've got a graph that will never be printed, and you just want to scale it up to screen size with no 'dead' space. I found that the Microsoft XPS Document Writer pseudo-printer had a large selection of sizes. And apparently some printer drivers allow you to enter a 'custom' size, but I haven't come across one of those.
benshepherd
Posted 2013-11-01T22:45:12.480
Reputation: 1 448
I wish I could upvote this answer twice... Like you said it is unfortunate that you can't enter a custom size. But changing to 11x17 layout instead of 8.5x11 layout makes the text in the graph much smaller, so now it isn't all scrunched up together like it was before. – ImaginaryHuman072889 – 2019-11-04T16:21:57.560
0
By design the newer versions of excel don't fill out the screen with the chart as much as with previous versions of Excel. Sorry.
guitarthrower
Posted 2013-11-01T22:45:12.480
Reputation: 933
Zooming in doesn't help you? – Hauke P. – 2013-11-05T18:46:55.750