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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 03:19 PM |
How do I make a 3-dimensional plot in Excel? | John W. Mordosky | Charts and Charting | 5 | December 16th, 2004 03:04 PM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |