 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to do it. Can anyone here please give me step by step primer. Thanks in advance. All I get is the graph of (1,2,............n) (x axis) against the n values of either col A or B. i.e 2 graphs instead of one. (In the old Lotus this was so simple: select the column for the X axis and then select the col for the Y and press enter, and you'd get the chart) Why is it so diff in Excel? Select the entire range you want to graph such as a2:b44>insert>chart>>>>  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I want to plot col A (x axis) against col B ( y axis). I cant seem to > do it. Can anyone here please give me step by step primer. Thanks in [quoted text clipped - 8 lines] > chart) > Why is it so diff in Excel? > Select the entire range you want to graph such as a2:b44>insert>chart>>>> > [quoted text clipped - 12 lines] > > (In the old Lotus this was so simple: select the column for the X axis > > and then select the col for the Y and press enter, and you'd get the doesnt work. > > chart) > > Why is it so diff in Excel? Hi, It will if you create a xy-scatter chart rather than a line chart. Also adding a textual series name over the second column and including that row in the range selection will help the chart wizard use the first column as x axis values/categories and the second column as y values. Cheers Andy >>Select the entire range you want to graph such as a2:b44>insert>chart>>>> >> [quoted text clipped - 18 lines] >>>chart) >>>Why is it so diff in Excel? > Hi, > [quoted text clipped - 29 lines] > >>>chart) > >>>Why is it so diff in Excel? Why must I use a scatter chart. i want to use a line chart. You mean it cant be done on a line chart? > > Hi, > > [quoted text clipped - 32 lines] > Why must I use a scatter chart. i want to use a line chart. You mean it > cant be done on a line chart? Ok yes I got it. It would seem like you said, I have to name the 2nd column. geez what a lousy software! Anyone can help me where I can download the lotus 1-2-3 for free? Thanks. If your x axis points are 1,2,3....n then you do not need the first column of data, which is confusing the wizard, as it will automatically create those categories for you. Cheers Andy >>>Hi, >>> [quoted text clipped - 36 lines] > column. geez what a lousy software! Anyone can help me where I can > download the lotus 1-2-3 for free? Thanks. it can, try it first... >> Hi, >> [quoted text clipped - 33 lines] > Why must I use a scatter chart. i want to use a line chart. You mean it > cant be done on a line chart? good question, trying to figure it out myself either... to clarify what he's asking x y a 45 29 b 8 47 c 45 44 d 43 40 he's trying to plot that, where a is point 1 at coordinate (45,29) etc etc... happy new year, orbii >I want to plot col A (x axis) against col B ( y axis). I cant seem to > do it. Can anyone here please give me step by step primer. Thanks in [quoted text clipped - 8 lines] > chart) > Why is it so diff in Excel?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.