ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Date format on axis in Excel 2007 (https://www.excelbanter.com/charts-charting-excel/175014-date-format-axis-excel-2007-a.html)

JAJ0111

Date format on axis in Excel 2007
 
I have Excel 2007 and my coworkers have Excel 2003. When they send me files
with charts, the date format in Excel 2007 is shown as numbers. Anyone
that has 2003 can see the correct format. I've checked the axis properties
on the version I see in 2007 and it says that it's formatted as a date.
What do I need to change in my settings to ensure the data is displaying
correctly?
--
J


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com