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

Pie Chart margins - can you reduce them?
 

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" wrote in message
oups.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

Pie Chart margins - can you reduce them?
 

On 13 Aug, 19:49, "Jon Peltier"
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" wrote in message

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