Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Graph Sizing

Posted on 2004-09-23
1
Medium Priority
?
380 Views
Last Modified: 2006-11-17
I have created an Excel graph.  Problem is the graph contains a lot of information.  Consequently, it is scrunched up on the page.  I have tried to stretch it so it fills up all of the space withing the box but it won't work.  Instead I have the bar graph with a large amount of blank space on each side of it within the charted area.  How can I fix this?  Thanks...
0
Comment
Question by:jz1english
1 Comment
 
LVL 20

Accepted Solution

by:
Serena Hsi earned 2000 total points
ID: 12137224
With each graph you create in Excel, there are two sizing options. One is for the overall Chart Area, you resize by dragging one of the corners and expanding width and length, and Excel automatically resizes (or tries to) the graph and its text.

The second sizing option is to click onto the bar chart itself. This selects the Plot Area. You can size that to whatever you want, expand it or shrink it. You may find that putting the legend at the top or bottom or in a floating text box will help you manage the visible area of the graph better. If you click onto the gray area (or white, if you've cleared the background formatting), it'll select the graph itself.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question