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  

How do u set the PLOT AREA to nearest mm in Excel Scatter Graph .



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2005, 01:07 PM
fh
external usenet poster
 
Posts: n/a
Default How do u set the PLOT AREA to nearest mm in Excel Scatter Graph .

I wish to plot x-y scatter graphs to scale e.g. on a landscape A4 size page.
I need the y (vertical) axis to be exactly 99mm long and the x (horizontal)
axis to be exactly 240mm long.

As I cannot find rulers in Excel I insert the graph in Word and turn on the
rulers. I then stretch the “chart area” until the axes are the correct length.

This usually works. However, sometimes it does not work e.g. the y axis
might be around 20mm too long for no apparent reason but the x axis will be
correct. I also notice that if a text box overlaps an axis the length of the
axis changes.

Is there another way of achieving graphs to scale? Can the size of the “plot
area” be set precisely?

Can you also let me know if there is some sort of “show all characters”
command in Excel, which could be used to identify empty text boxes, which are
invisible?

 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I plot XYZ points in excel? dgs348 Charts and Charting 2 September 18th, 2007 04:00 PM
I cannot type in my Excel program. The Font and size area is shad. ohana Worksheet Functions 1 April 21st, 2005 04:48 PM
Bar Chart Label Sizes [email protected] Charts and Charting 2 December 27th, 2004 04:19 PM
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting 5 December 16th, 2004 04:04 PM
outputting memo fields to excel John Baker Running & Setting Up Queries 7 August 12th, 2004 01:23 PM


All times are GMT +1. The time now is 12:15 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.