If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Decreasing white space around graphs in Excel?
I want to increase the size of a pie chart within its window in Excel, but I
don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#2
|
|||
|
|||
Try selecting (clicking) the outside of the pie chart itself (plot area it
may be called), and not the square border that surrounds it. that will allow you to expand the size of the pie without expanding the border box around it. "guenthj" wrote in message ... I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#3
|
|||
|
|||
Actually, to select the plot area of a pie chart, you have to click in
the corners between the circle and the square it fits within. With this square highlighted, drag the corners outward to increase its size. All about pie charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=390 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: Try selecting (clicking) the outside of the pie chart itself (plot area it may be called), and not the square border that surrounds it. that will allow you to expand the size of the pie without expanding the border box around it. "guenthj" wrote in message ... I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#4
|
|||
|
|||
Kind of a puzzler, but when I hover the cursor over one of the corners of the
box, it changes to a two headed arrow, but clicking and dragging does nothing. Can't enlarge the overall size oif the pie. Could this be locked, somehow? "Jon Peltier" wrote: Actually, to select the plot area of a pie chart, you have to click in the corners between the circle and the square it fits within. With this square highlighted, drag the corners outward to increase its size. All about pie charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=390 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: Try selecting (clicking) the outside of the pie chart itself (plot area it may be called), and not the square border that surrounds it. that will allow you to expand the size of the pie without expanding the border box around it. "guenthj" wrote in message ... I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#5
|
|||
|
|||
Hi,
If the sheet has been protected then you could see this effect. Have a look under menus Tools Protection Cheers Andy jmdaniel wrote: Kind of a puzzler, but when I hover the cursor over one of the corners of the box, it changes to a two headed arrow, but clicking and dragging does nothing. Can't enlarge the overall size oif the pie. Could this be locked, somehow? "Jon Peltier" wrote: Actually, to select the plot area of a pie chart, you have to click in the corners between the circle and the square it fits within. With this square highlighted, drag the corners outward to increase its size. All about pie charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=390 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: Try selecting (clicking) the outside of the pie chart itself (plot area it may be called), and not the square border that surrounds it. that will allow you to expand the size of the pie without expanding the border box around it. "guenthj" wrote in message ... I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
Nope, the sheet isn't protected....
"Andy Pope" wrote: Hi, If the sheet has been protected then you could see this effect. Have a look under menus Tools Protection Cheers Andy jmdaniel wrote: Kind of a puzzler, but when I hover the cursor over one of the corners of the box, it changes to a two headed arrow, but clicking and dragging does nothing. Can't enlarge the overall size oif the pie. Could this be locked, somehow? "Jon Peltier" wrote: Actually, to select the plot area of a pie chart, you have to click in the corners between the circle and the square it fits within. With this square highlighted, drag the corners outward to increase its size. All about pie charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=390 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: Try selecting (clicking) the outside of the pie chart itself (plot area it may be called), and not the square border that surrounds it. that will allow you to expand the size of the pie without expanding the border box around it. "guenthj" wrote in message ... I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
|
|||
|
|||
I too want to do this. When selecting just the plot area, it does not allow
"copy" as an option. I just want the pie chart and not the extra white space. The chart area will enlarge/reduce everything. HELP. Protection is off also. "guenthj" wrote: I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#8
|
|||
|
|||
Found it in another post so will share - Thanks to Jon Peltier who replied to
a post.. If you want to keep your chart as a chart, it's not so easy. First you need to format all the text elements in the chart, and uncheck the Autoscale box on the Font tab. This prevents everything from changing in size. Then you have to shrink the chart area (the larger outer box) and expand the plot area (the inner box) in a coordinated effort. This works well. You have to do the chart area, then the plot area and play with the positioning until they come close to each other. but id does eliminate alot of the extra white space around the graphics. Thanks Jon "charlotte" wrote: I too want to do this. When selecting just the plot area, it does not allow "copy" as an option. I just want the pie chart and not the extra white space. The chart area will enlarge/reduce everything. HELP. Protection is off also. "guenthj" wrote: I want to increase the size of a pie chart within its window in Excel, but I don't want to increase the amount of white space surrounding it. I want to paste the chart into a small area in Publisher, but when I do I get a lot of wasted space around the chart. |
#9
|
|||
|
|||
"charlotte" wrote in message
... Found it in another post so will share - Thanks to Jon Peltier who replied to a post.. If you want to keep your chart as a chart, it's not so easy. First you need to format all the text elements in the chart, and uncheck the Autoscale box on the Font tab. This prevents everything from changing in size. Then you have to shrink the chart area (the larger outer box) and expand the plot area (the inner box) in a coordinated effort. This works well. You have to do the chart area, then the plot area and play with the positioning until they come close to each other. but id does eliminate alot of the extra white space around the graphics. Thanks Jon Hi Charlotte, Do you mean that, in addition to deselecting the autoscale option, you also have to set each and every property (font, size, position, ..... etc etc etc) for each chart? If so, is that best done programmatically in order to ensure that *every* property is manually set? Thanks, Alan. |
#10
|
|||
|
|||
Alan -
You can set the Autoscale to false with a simple macro, and set it as your default with a registry tweak. Both of these are covered in this web page: http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Alan wrote: "charlotte" wrote in message ... Found it in another post so will share - Thanks to Jon Peltier who replied to a post.. If you want to keep your chart as a chart, it's not so easy. First you need to format all the text elements in the chart, and uncheck the Autoscale box on the Font tab. This prevents everything from changing in size. Then you have to shrink the chart area (the larger outer box) and expand the plot area (the inner box) in a coordinated effort. This works well. You have to do the chart area, then the plot area and play with the positioning until they come close to each other. but id does eliminate alot of the extra white space around the graphics. Thanks Jon Hi Charlotte, Do you mean that, in addition to deselecting the autoscale option, you also have to set each and every property (font, size, position, ..... etc etc etc) for each chart? If so, is that best done programmatically in order to ensure that *every* property is manually set? Thanks, Alan. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |
Increasing line weight in Excel graphs | farzin | General Discussions | 0 | June 3rd, 2004 01:18 AM |