LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 36
Default Date display on chart

I am using Excel 2007, Windows XP Sp2 and I am a newbie to Excel.
I have a diabetic program so when my readings are entered into a Palm T3
pda, after syncing, the program uses Excel 2007 to chart the results.
Looking at the data cells, the date is formated as dd.mm.yy.
Looking at the bottom of the Excel chart, it only shows dd.mm and no year.
I would like the chart to show mm.dd.yy when Excel graphs my diabetic
readings.
When opening the data file, a pop up says it is a "read-only" file.
Am I able to change the bottom of the chart to show the dates as mm.dd.yy?
If you can, then how.
Thanks


 
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
X axis date - display beyond latest date. Dave F. Charts and Charting in Excel 1 January 3rd 07 03:17 AM
Display Date on Chart diablo Charts and Charting in Excel 11 November 18th 06 06:41 PM
Can I display an Excel chart as my screensaver display? Burke Charts and Charting in Excel 0 August 1st 06 07:01 PM
How to display a series in chart table and not in the chart? Mani Charts and Charting in Excel 1 February 22nd 06 04:38 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM


All times are GMT +1. The time now is 02:28 AM.

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"