4

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?

  • Zooming in doesn't help you? – Hauke P. Nov 5 '13 at 18:46
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.

  • 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 Nov 4 '19 at 16:21
1

I use Excel 2016 and had the same problem today and didn't want to accept the selection of a suitable printer as a solution. So I looked for something better and found exactly what I and you need:

Instead of changing the printer, just change the borders of the page until you reach a ratio of usable area on the page that matches your screen aspect ratio!

Example:
I have a 16:9 screen with 1920x1080 (should be the default today), and my default page size is "A4 landscape", which means I have a lot of unused grey area on the left and right.
By changing the top and bottom frame size of the page to about 4.5 cm and the left and right to 0 cm, I was able to fill the whole screen with my diagram, see the following screenshot: enter image description here

Notice, that the texts will appear larger because they consume a larger part of the reduced usable area now, so you have to lower the text size. I used 4pt for the horizontal bar and 6pt for the vertical bar.

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.