Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart title date format

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
An interesting one: I have a chart with a date as the x-axis. The date format is mm/dd/yy. The chart is on a separate chart sheet. The sheet has a Chart_Activate event handler which checks some worksheet data and, if necessary, adjusts the series data ranges to accommodate new data. This all works fine.
Here's the funny thing: when I the chart handler makes an adjustment, the date format goes to mm/dd/yyyy. When I leave the sheet and come back in again, it's mm/dd/yy once again. Any ideas why it temporarily gets out of whack?
Rob
[flowerface]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top