Solved

Excel Graph Sizing

Posted on 2004-09-23
1
370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
Serena Hsi earned 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mobile app idea 17 108
Create workstation base image 4 88
application server backups 2 41
I am looking for a reliable program to clone servers 5 107
Let’s list some of the technologies that enable smooth teleworking. 
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

759 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