A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Seemingly random plot area drift?



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 18th, 2010, 05:31 PM posted to microsoft.public.excel.charting
MKArchibald
external usenet poster
 
Posts: 1
Default Seemingly random plot area drift?

I've got a really frustrating issue with Excel charts. I am using Excel 2003
SP3 and XP.

I have a large workbook with many tabs. One of the tabs has about a dozen
bar charts. Every time I copy these charts into Word, and then go back to
Excel, the plot area has randomly moved. I don't do ANYTHING in this tab
except copy and paste those graphs. There is no shifting of column widths
etc.

Specifically, the plot area seems to shrink. I make a quarterly report with
these graphs and each quarter the plot area has shrunk until it gets so small
and scrunched into the middle of the graph that I have ot go back and
manually stretch the graphs out again. The problem is twofold:

1. Why does this random movement of the plot area happen? I'll not also that
the legend also seems to move.

2. My workaround of going back each quarter and manually stretching the plot
area back to fill the chart is also frustrating, time consuming, and
impossible to do perfectly the same in each of the 12 graphs because I'm
having to do it by eye. Why does Excel not have rulers and/or measured plot
area options? It seems you can only change sizes by eye. Therefore my report
looks unprofessional and messy because the graphs aren't all bang on the same.

Any help would be greatly appreciated!
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.