LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
afsarul
 
Posts: n/a
Default Uniform Year Axis in Excel


Hi,

I'm currently in the middle of (what I believe to be :) ) my
world-shattering dissertation on when world oil will peak. But I'm
stuck on the simplest of issues. I have graphes (300+) which on the
y-axis display production/reserves ranges for different countries and
on the x-axis display a year range from pre 1900 to 2025. But the year
range is not uniform e.g Pre -, 1904, 1909, 1914 ....... 2024. I mean
it is actually uniform i.e in steps of 5, but I would like the axis to
read Pre -, 1900, 1905, 1910, ...... 2025. I've tried fiddling around
by change from line to scatter graphes, or by changing the number of
catagories between tick mark labels, but to no avail. The problem (as I
see it) lies with the 'Pre-' label which is at the beginning of the
range. But I don't know what to do. Even my University can't seem to
help. Please, any help would be much appreciated. My supervisor is
super-excited to publish my information so that he can send a political
message to the world about the impending world oil shortage.

Kind Regards,

Saad


--
afsarul
------------------------------------------------------------------------
afsarul's Profile: http://www.excelforum.com/member.php...o&userid=24203
View this thread: http://www.excelforum.com/showthread...hreadid=378166

 
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
How do I change the size of Value Axis Title box for an Excel Cha. LISSJMC Charts and Charting in Excel 1 April 11th 05 03:36 PM
axis break graphing in excel DKS Charts and Charting in Excel 1 March 30th 05 10:04 PM
How do I break the value (Y) axis in an Excel chart ?? JimP Charts and Charting in Excel 1 February 11th 05 06:22 PM
Excel cut/paste prob: Adds one day and changes year to 2009 Maisha1908 Excel Discussion (Misc queries) 3 February 7th 05 07:19 PM
How do I get a second Y axis in Excel 2000 Cathy1114 Charts and Charting in Excel 2 January 20th 05 12:58 AM


All times are GMT +1. The time now is 09:27 PM.

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

About Us

"It's about Microsoft Excel"