Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can you place dates from1996-2006 on the x axis?
I am trying to create a that shows the dates 1996-2006 on the x axis.
Everytime I try to change the the time scale showing these years the line graph information disappears. Can someone pls help. thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can you place dates from1996-2006 on the x axis?
1996-2006 are not dates, they are years. If you tell a chart to use the date
1996, it thinks you mean the 1996th day in Excel's calendar system, which was 18 June 1905. You have at least three choices: 1. Use a category scale with years as X labels. 2. Use dates, like 1/1/1996, 1/1/1997, etc. 3. Use an XY chart with years as X values. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tomeka" wrote in message ... I am trying to create a that shows the dates 1996-2006 on the x axis. Everytime I try to change the the time scale showing these years the line graph information disappears. Can someone pls help. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
All Excel Dates show as 2006 | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
I need an academic school calendar for 2006-2007 with a place for | Excel Discussion (Misc queries) | |||
how do I combine monthly dates ex: jan 1,2005+jan 1,2006 together. | Excel Discussion (Misc queries) |