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
|
|||
|
|||
Excel reformatting a date axis to January
I am trying to create a chart using data which has date as one heading, 31
March 2005, when I create the chart, this seems to default to January and I cannot find a way to set to the prcise date I am using. I eventually want this chart in PowerPoint but.......... Any ideas? i am using Office 2007 Cheers all |
#2
|
|||
|
|||
Excel reformatting a date axis to January
It's probably defaulting to January 1 1900, day 1 in Excel's date system.
You are not providing valid dates for the chart to use as dates. Make sure the apparent dates in the worksheets are numerical dates, not text labels, then make sure the X values (category labels for the chart) refers to these dates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "scoz" wrote in message ... I am trying to create a chart using data which has date as one heading, 31 March 2005, when I create the chart, this seems to default to January and I cannot find a way to set to the prcise date I am using. I eventually want this chart in PowerPoint but.......... Any ideas? i am using Office 2007 Cheers all |
Thread Tools | |
Display Modes | |
|
|