ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   setting dates in a timeline (https://www.excelbanter.com/charts-charting-excel/159014-setting-dates-timeline.html)

suzie marie

setting dates in a timeline
 
I am using Excel 2003. I have created a timeline, and but when I try to
format the x-axis for the months and years of my daughter's life, I get her
birth year twice, and the final year of the timeline twice. Also- the data
appears on the timeline 1 year behind the legend. Can you tell me how to set
the formatting to get mm/yy?

Jon Peltier

setting dates in a timeline
 
What does your data look like, and what kind of chart is it?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"suzie marie" wrote in message
...
I am using Excel 2003. I have created a timeline, and but when I try to
format the x-axis for the months and years of my daughter's life, I get
her
birth year twice, and the final year of the timeline twice. Also- the data
appears on the timeline 1 year behind the legend. Can you tell me how to
set
the formatting to get mm/yy?





All times are GMT +1. The time now is 07:52 AM.

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