how do you resize a chart (pie chart, for example) without resizing the cell? And, also, where do I find the size of the actual pie chart, not the size of the whole thing. Thanks!
how do you resize a chart (pie chart, for example) without resizing the cell? And, also, where do I find the size of the actual pie chart, not the size of the whole thing. Thanks!
Last edited by cehs; 07-10-2009 at 12:28 PM.
Charts embedded in a worksheet are objects separate from the worksheet (though "layered" on top of them). As such they are resized only by one of two ways:
- Selecting the chart and dragging the border to the desired size
- VBA code to manipulate the chart properties
The "pie area" you refer to is called the plot area and it is also resized in the same way.
There is no need to resize a cell to accomodate a chart.
Optionally, you can put a chart in its own special sheet called a chart sheet by selecting the chart, right-clicking and choosing "Move Chart" from the pop up menu. In the resulting dialog choose New Sheet for the chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks