Excel - Techist - Tech Forum

 Techist - Tech Forum Excel
 User Name Remember Me? Password
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
 Thread Tools Display Modes

 09-30-2005, 06:05 AM #1 (permalink) Junior Techie   Join Date: Jan 2004 Posts: 56 Excel hi all... i have small doubt...in EXCEL 2003 i need to draw a line graph..... let the values be 30 30.1 30.2 30.3 30.4 30.5 30.8 31 what i need to have is the x axis should start from 40 to 48 and i need to specify the incrementing value as 0.5 say....ie the scale the y axis should start from zero..... the intersection of the two axis should be at (40,0) right ... help me out __________________
 09-30-2005, 07:56 AM #2 (permalink) Banned   Join Date: Sep 2005 Posts: 70 Explain it to me again and I will help: Y axis from bottom to top starts from 0 to ? X axis from left to right starts from 40, 40.5, 41, 41.5, 42, 42.5 upwards to 48 The plotted line on the graph has the values 30, 30.1, 30.2, 30.3, 30.4, 30.5, 30.8, 31 I must have understood it wrongly as these values would not produce a proper graph, the values of the plotted line on the graph should be in the same numerical range as one of the axis, 30 to 31 does not fall in the range 40 to 48, the number of points to plot on the graph line also does not correspond to the number of integral values plotted along either of the axis. If you write it in the following layout I will help you or maybe I am just stupid and someone else knows what your on about and can work it out: Y axis from bottom to top starts from ?, ?, ?, ?, upwards to ? X axis from left to right starts from ?, ?, ?, ?, upwards to ? The plotted line on the graph has the values ?, ?, ?, ? __________________
 10-01-2005, 09:26 AM #3 (permalink) Junior Techie   Join Date: Jan 2004 Posts: 56 i dont know what u understood...... what i asked was...... the values to be plotted in the line graph are 30, 30.1, 30.2, 30.3, 30.4, 30.5, 30.8, 31 the values in the x axis should be from 40, 40.5....43 the values in the y axis should be from 0 to 40 ie. with respect to the x value 40 the y value should be 30..and it goes on.... ie the x axis values should start from 40 to 44 ( ie i should specify the values, these values are just examples) the y axis values should be from 0.... in both axis i should specify the values at which the two axes intersect (in this case it is 40,0) and i should specify the incremental values ie the scale (in this case 0.5 in axis and 1 in y axis) is this possible in excel and am i making myself clear..... kindly help me out.... i guess this is a simple problem thanx for any help....
 10-01-2005, 12:08 PM #4 (permalink) Junior Techie   Join Date: Sep 2005 Posts: 61 reply graphs r used to convey information in graphical manner so that others understand only wht u wnt them to,now when u post numbers ,it' confuses the readers as to wht u want.just ask the people here how to draw a particular graph and they will tell u. plz be clear as to want u want.
 10-02-2005, 12:33 AM #5 (permalink) Junior Techie   Join Date: Jan 2004 Posts: 56 excel the figures are just illustration and not intended for confusing.... try reading it twice..i'm clear i guess.... just in two lines... i need to specify the values at which the two axes inntersect and the scale for two axes this is what i want... thanx for any help
 10-02-2005, 12:08 PM #6 (permalink) Ultra Techie   Join Date: Mar 2004 Posts: 694 I thought i had a correct answer, but i cant seem to relay it. Why is it so important to know where the axes intersect? Can you give us some actual numbers you want to graph? If you can, perhaps we could work it out and then tell you what we came up with. Then you could look at the solution and figure it out. __________________ Lian Li Aluminum Case Intel D975XBXK2R Mobo Core 2 Duo E6700 CPU EVGA 8800 GTS Video Card Corsair XMS 2 x 1gig RAM Zalman 9500 CPU cooler
 10-02-2005, 12:36 PM #7 (permalink) Ultra Techie   Join Date: Mar 2004 Posts: 694 Ok, here's what i was looking for. If you graph a line in excel, the program is going to generate the graph based on your values, line type and so on. The scale you choose for the X axis will determine where the two axes intercept each other. for example if you have 5 values for "Y" (Any values) labeled "1,2,3,4,5" on the X axis, the Y axis will intercept the X axis at (0.5,?). The "?" represents the minimum value of the "Y" axis Now if you have the same 5 values for "Y" and change the X-axis labels to "2,4,6,8,10" on the x axis, the Y axis will intercept the X axis at (1,?). The "?" represents the minimum value of the "Y" axis Now if you have the same 5 values for "Y" and change the X-axis labels to "20,40,60,80,100" on the x axis, the Y axis will intercept the X axis at (10,?). The "?" represents the minimum value of the "Y" axis I hope that makes sense. __________________ __________________ Lian Li Aluminum Case Intel D975XBXK2R Mobo Core 2 Duo E6700 CPU EVGA 8800 GTS Video Card Corsair XMS 2 x 1gig RAM Zalman 9500 CPU cooler

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

#### Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

#### Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

#### Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities