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.

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.

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.

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.

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

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

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.

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.

"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.

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.