Solved

Excel Graph Sizing

Posted on 2004-09-23
1
369 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: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
WinxDVD Platinum 12 60
All doc, xls, and pdf's are gone 9 92
MSP multi use software 4 134
Automatic dictation/transcribing software 9 47
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
This video shows how use content aware, what it’s used for, and when to use it over other tools.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.

830 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