ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   resize chart (https://www.excelbanter.com/charts-charting-excel/114546-resize-chart.html)

ayesha

resize chart
 
i want to resize a pie chart in excel without resizing the space around it.
ie i want the border around the chart to fit closely to the chart. any ideas?

Andy Pope

resize chart
 
Hi,

You can resize the actual pie part of the chart by selecting the
plotarea (square box bounding the slices).

Select the chart and use the Up/Down cursor key to cycle thru the chart
elements. Once the plotarea is selected you can drag to resize.

Or use the chart toolbar to select the plotarea.

Or to click it, image the pie is in a box so click a corner area close
to the slices at roughly the 2,5,7 or 11 o'clock positions.

Cheers
Andy

ayesha wrote:
i want to resize a pie chart in excel without resizing the space around it.
ie i want the border around the chart to fit closely to the chart. any ideas?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com