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
|
|||
|
|||
An uneven time-increment
Dear all, If in a spreadsheet you have years 1985, 1986, 1987, 1988, 1989, 1990, 2050 with associated data for each year, how do you produce a line graph of this without 2050 being positioned at the same interval on the x-axis as the difference between the other years? To clarify, because the difference between 2050 and 1990 is greater than the difference between the previous years (all 1), how do get Excel to represent this on the x-axis of a line graph? Thanks for your help, Steve -- smurray444 ------------------------------------------------------------------------ smurray444's Profile: http://www.excelforum.com/member.php...o&userid=28956 View this thread: http://www.excelforum.com/showthread...hreadid=509485 |
#2
|
|||
|
|||
An uneven time-increment
Steve -
There are two ways, both involving the use of a time scale axis. Method 1. In the worksheet, change the years to dates like the first of each year, or 1/1/1985, 1/1/1986. Then recreate the chart. Excel is likely to generate a time-scale axis without human intervention, and the spaces between points will reflect the years between points. If Excel still doesn't make a time scale axis, choose Chart Options from the Chart menu, and on the Axes tab, under Category X Axis select the Time-Scale option. Method 2. Leave the years as they are. Change to a time-scale axis: choose Chart Options from the Chart menu, and on the Axes tab, under Category X Axis select the Time-Scale option. Excel converts the years to a date, but it's based on the number of days since 1/1/1900 (and 1985, for example, reads like 6/7/1905). Double click the axis, and on the Number tab, change the number format to General. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "smurray444" wrote in message ... Dear all, If in a spreadsheet you have years 1985, 1986, 1987, 1988, 1989, 1990, 2050 with associated data for each year, how do you produce a line graph of this without 2050 being positioned at the same interval on the x-axis as the difference between the other years? To clarify, because the difference between 2050 and 1990 is greater than the difference between the previous years (all 1), how do get Excel to represent this on the x-axis of a line graph? Thanks for your help, Steve -- smurray444 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date & Time internationalisation | Nick Stansbury | General Discussion | 0 | October 27th, 2005 05:01 PM |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
Time Zone Scheduling | JohnA | Calendar | 0 | September 14th, 2004 08:15 PM |
Time performance Chart | Bull Splat | Charts and Charting | 6 | November 10th, 2003 02:16 PM |