Pie Chart margins - can you reduce them?

Hi All

I am preparing reports with a lot of pie charts. I have to fit at
least six onto one A4 page so that they can all be viewed easily.

I have noticed that the pie charts have a lot of wasted space in what
seem to be margins surrounding the actual pie pieces. This is causing
me troubles as when I squeeze six onto a page the actual pies are
quite small.

I have had no luck in making the pies bigger in relation to their
surrounding chart area.

Is it possible to reduce these margins?

Thanks for any ideas in advance,
Chris

You need to select the plot area of the chart. In a pie chart, this means
clicking in the ~triangular region in the corners of the chart, between the
pie's circular outline and the plot area's square outline. Once this is
selected, you can drag the corners outward to stretch the pie.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chrisso" <chris75sutton@gmail.com> wrote in message
news:1187021774.886462.210280@k79g2000hse.googlegroups.com...
> Hi All
>
> I am preparing reports with a lot of pie charts. I have to fit at
> least six onto one A4 page so that they can all be viewed easily.
>
> I have noticed that the pie charts have a lot of wasted space in what
> seem to be margins surrounding the actual pie pieces. This is causing
> me troubles as when I squeeze six onto a page the actual pies are
> quite small.
>
> I have had no luck in making the pies bigger in relation to their
> surrounding chart area.
>
> Is it possible to reduce these margins?
>
> Thanks for any ideas in advance,
> Chris
>

On 13 Aug, 19:49, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> You need to select the plot area of the chart. In a pie chart, this means
> clicking in the ~triangular region in the corners of the chart, between the
> pie's circular outline and the plot area's square outline. Once this is
> selected, you can drag the corners outward to stretch the pie.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> "Chrisso" <chris75sut...@gmail.com> wrote in message
>
> news:1187021774.886462.210280@k79g2000hse.googlegroups.com...
>
>
>
> > Hi All
>
> > I am preparing reports with a lot of pie charts. I have to fit at
> > least six onto one A4 page so that they can all be viewed easily.
>
> > I have noticed that the pie charts have a lot of wasted space in what
> > seem to be margins surrounding the actual pie pieces. This is causing
> > me troubles as when I squeeze six onto a page the actual pies are
> > quite small.
>
> > I have had no luck in making the pies bigger in relation to their
> > surrounding chart area.
>
> > Is it possible to reduce these margins?
>
> > Thanks for any ideas in advance,
> > Chris- Hide quoted text -
>
> - Show quoted text -

Cheers Jon. Chrisso