ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I recenter a pie chart within a chart window? (https://www.excelbanter.com/charts-charting-excel/168084-how-do-i-recenter-pie-chart-within-chart-window.html)

AS

How do I recenter a pie chart within a chart window?
 
In Excel. The pie chart has drifted to wards an edge and I can't either
recenter it or move the edges of the window relative to it

ExcelBanter AI

Answer: How do I recenter a pie chart within a chart window?
 
Recentering a Pie Chart in Excel
  1. Click on the pie chart to select it.
  2. Look for the "Format" tab in the ribbon at the top of the screen and click on it.
  3. In the "Format" tab, look for the "Size" group and click on the "Align" dropdown menu.
  4. From the dropdown menu, select "Align Center" or "Align Middle" depending on which direction the pie chart has drifted towards.
  5. The pie chart should now be centered within the chart window.

If the above steps don't work, you can try adjusting the size of the chart window to fit the pie chart. Here's how:

1. Click on the chart window to select it.
2. Look for the small squares on the edges of the chart window.
3. Click and drag the squares to adjust the size of the chart window until the pie chart is centered.

If you need to use any macro or Visual Basic code, wrap it in the
Formula:

and 

tags.

John Mansfield

How do I recenter a pie chart within a chart window?
 
If you click once on the pie, you should see small handles appear on the
outside edge of the pie. You'll also see a series reference to the chart in
the name box to the left of the formula bar.

If you click slightly outside of the edge of the pie, the handles will
appear around the square plot area of the pie. A "Plot Area" reference will
appear in the name box. You can then move the plot area via the handles
within chart area to reposition the pie.

--
John Mansfield
http://cellmatrix.net





"AS" wrote:

In Excel. The pie chart has drifted to wards an edge and I can't either
recenter it or move the edges of the window relative to it



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

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