Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
AS AS is offline
external usenet poster
 
Posts: 11
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Display -- fit window or zoomable? SpreadsheetBrian Excel Discussion (Misc queries) 1 June 20th 07 10:53 PM
Resizing Chart window using VBA Barb Reinhardt Charts and Charting in Excel 1 April 13th 07 02:23 PM
How to make a Chart with a Variable Data Window Jay Somerset Excel Discussion (Misc queries) 2 January 19th 07 05:41 PM
Chart Titles not showing in excel chart Window Greg_tnwre Excel Discussion (Misc queries) 0 July 15th 06 03:41 AM
How do you change a chart window name? MEMEMEMEMEMEME Excel Discussion (Misc queries) 1 October 18th 05 09:59 PM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"