LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Qwerty
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph with variable data length snoach Excel Discussion (Misc queries) 1 May 27th 05 10:15 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"