Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graphing error using Time as X axis. | Excel Worksheet Functions | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |