![]() Let me know if you have any further questions. 2008 for Mac is buggy, so if we can't come up with a solution for why Excel is starting the English line at -44 instead of at 0, it may very well be due to a glitch in the program itself. The menu layout in Excel 2008 for Mac is a bit different from the one in 2007 for Windows, so I am still trying to find the interpolate function (I'll keep working on 's got to be here somewhere). ![]() and select data for x-axis (A2:A17)Ĥ.) Go to Chart>Add Data. Here is a step-by-step description of what I did to create my version of the graph:ģ.) Go to Chart>Source Data. Do you have any idea what might be causing Excel to start the English line at -44, despite that the values in the spreadsheet for the English dataset don't start until 0? (Perhaps I should try selecting the Russian data first, although I don't see why this would make a difference.) I double-checked the values for the data ranges for both lines to ensure that they run from rows B2-B17 and C2:C17, and that the x-axis values in both cases also run from A2:A17. However, I tried to replicate what you had done myself, but on my version of the graph (which I am attaching), the English line starts at -44 instead of at 0. Thanks for sending me the example graph (which displays as I would like it to on my version of Excel) and explaining to me how to select the data to create the type of graph that I want. Thanks in advance for any help that anyone can offer. ![]() I am using Excel 2008 for Mac, but I would imagine that this function in the 2007 for Windows version would work similarly.Ī prompt response would be especially appreciated, given that I am doing this for a paper that is due tomorrow (I am a student). Thus, both lines would be on the same axis, and would start and end at different points, but would overlap slightly. What I want is for, say, the x-axis to range from -44 to 60, and the first line should start at -44 and end at 10, and the second should start at 0 and end at 60. I have tried selecting both the whole range of x-axis values as well as each individual range, to no avail. I know how to create the two lines, but when I try to select the x-axis values, Excel defaults the second line's first point at the value at which the first line starts. A single line graph means that only one independent variable is being measured or tracked across multiple time intervals. I am trying to create a line chart in Excel with two lines, each of which starts and ends at a different x axis value, but which overlap slightly.
0 Comments
Leave a Reply. |