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
|
|||
|
|||
Challenging Graph problem!
Ok, for one of my assignments I have to re-create a graph from the IPCC (climate change scientists). I have worked a couple of hours on it, but now I am definatly stuck and I don't progress anymore, and it is really, really bugging me. Ok, so here we go: This is the graph we have to re-create, it only is the TOP graph. (clickable) '[image: http://i16.photobucket.com/albums/b16/Taaie-Neuskoek/th_excel-assignment.jpg]' (http://i16.photobucket.com/albums/b1...assignment.jpg) I have the datafile, it is just two rows rows, one with dates the other one with nrs, so no need to post that I think . So, where did I get? I did get the x-axes marks down (so the dates are not messing with the columns), but cannot get the line and the tick-marks down. Also, how to get the ticked lines on the right side and on top? I chose as chart-type a normal column, there are others like "line-column on 2 axes", but if I try to import my data in it I get a complete mess. Also, I got the tick marks on the left side done, but the tick marks are a lot smaller than they appear in the 'official' graph... I hope there's someone here who might give me hints to solve this... The excel help file doesn't get me any further... -- Qwerty ------------------------------------------------------------------------ Qwerty's Profile: http://www.excelforum.com/member.php...o&userid=29599 View this thread: http://www.excelforum.com/showthread...hreadid=493002 |
#3
|
|||
|
|||
Challenging Graph problem!
Thanks for your very quick reply, it did help! I am in the meanwhile further thanks to a friend of mine and the reply here- I got most things sorted, exept for one small annoying thing - the tick marks on the X-axes. I cannot set that it should cross the Y-axes at -1, becasue I also have negative timepoints, which 'fall down' of the axes... (see picture in OP, it is clear) I managed to get a line there, and with the drawing function one can draw tickmark themselve, but that is not very scientific... is it? And further, which is more an interpertation question: In the graph we have to re-create it states: "The smoothed curve was created using a 21-time point binominal filter giving near decadal averages. Does anyone have a cleu what this means. -- Qwerty ------------------------------------------------------------------------ Qwerty's Profile: http://www.excelforum.com/member.php...o&userid=29599 View this thread: http://www.excelforum.com/showthread...hreadid=493002 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graph Problem | DJ | Setting Up & Running Reports | 3 | October 21st, 2005 05:04 PM |
Strange problem with different networks. | Adam | General Discussion | 1 | March 13th, 2005 10:17 PM |
Graph Problem | Researcher12 | Setting Up & Running Reports | 0 | March 2nd, 2005 01:33 PM |
PGP problem | Bob Henson | General Discussion | 0 | June 27th, 2004 11:28 AM |
Dynamically control how many lines on a graph? | Keith R | Charts and Charting | 2 | October 22nd, 2003 04:19 PM |