Solved

Excel Graph Sizing

Posted on 2004-09-23
1
373 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

626 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