Solved

Excel Graph Sizing

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

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Team Foundation Server 8 61
Can I download Google sheets program to my PC? 13 83
JKS to store upstart data 2 84
Win 7 OS unable to install Win updates 3 138
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now