Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default x-axis is time ... sort of

I'm trying to create a chart in Excel like the one on this page:

http://finance.yahoo.com/bonds/composite_bond_rates

If the above link doesn't show up, you can get to the page by going to
Yahoo Finance and clicking on "Rates", which is about half way down on
the left side.

The x-axis on this chart is not time as in dates, but it is time as in
length of period (e.g. 3 days, 3 months, 3 years...) and the spacing
between x-axis labels is scaled by time period (not equally spaced).

I can do this in Excel using x-y scatter and x-axis data as # of days
(1 for 1 day, 365 for 1 year, 10950 for 30 years, etc), but the x-axis
labels are, obviously, the number of days (e.g. it says "3650" instead
of "10y" or "10 years"). Is there a way to make the x-axis labels say,
for example, "1y" instead of "365" and still have them spaced
correctly, like they are on the page above? Thanks.

  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default x-axis is time ... sort of

Use this technique to apply the desired data labels in place of the regular
axis tick labels:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


wrote in message
oups.com...
I'm trying to create a chart in Excel like the one on this page:

http://finance.yahoo.com/bonds/composite_bond_rates

If the above link doesn't show up, you can get to the page by going to
Yahoo Finance and clicking on "Rates", which is about half way down on
the left side.

The x-axis on this chart is not time as in dates, but it is time as in
length of period (e.g. 3 days, 3 months, 3 years...) and the spacing
between x-axis labels is scaled by time period (not equally spaced).

I can do this in Excel using x-y scatter and x-axis data as # of days
(1 for 1 day, 365 for 1 year, 10950 for 30 years, etc), but the x-axis
labels are, obviously, the number of days (e.g. it says "3650" instead
of "10y" or "10 years"). Is there a way to make the x-axis labels say,
for example, "1y" instead of "365" and still have them spaced
correctly, like they are on the page above? Thanks.



Reply
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
Graphing error using Time as X axis. pete3589 Excel Worksheet Functions 2 December 16th 05 04:50 PM
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
conditional formatting with time values Access Idiot Excel Discussion (Misc queries) 2 September 13th 05 03:29 PM
time differences in a column 68magnolia71 Excel Worksheet Functions 3 May 9th 05 09:46 PM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 11:57 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"