#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 138
Default Size of Chart

Hi, I am trying to add a pie chart into an excel document. It automatically
sizes itself and when I drag to resize, it shrinks the chart itself too much
and there is a lot of wasted white space around the chart. Is there a way
when I create the chart that I can specify which cells the chart needs to fit
into?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Size of Chart

Select the plot area (use the dropdown on the Chart toolbar, or click in the
corners of the square defined by the pie's circle), then drag the edges
outward to expand the pie within the chart area.

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


"Paula" wrote in message
...
Hi, I am trying to add a pie chart into an excel document. It
automatically
sizes itself and when I drag to resize, it shrinks the chart itself too
much
and there is a lot of wasted white space around the chart. Is there a way
when I create the chart that I can specify which cells the chart needs to
fit
into?



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 size [email protected] Charts and Charting in Excel 1 May 17th 07 05:15 PM
chart area size vba [email protected] Charts and Charting in Excel 1 September 6th 06 03:57 PM
Change Chart Size bhavesh Charts and Charting in Excel 1 August 2nd 06 10:30 AM
Chart size JKC Charts and Charting in Excel 1 February 14th 06 04:30 PM
chart size zdenek Charts and Charting in Excel 0 February 9th 06 09:58 AM


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

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

About Us

"It's about Microsoft Excel"