User (Legacy) Posted June 18, 2002 Report Share Posted June 18, 2002 I am unable to use a custom formatting mask with my date fields on the x-axis. Here is the code I am using to set up the formatting of the axis: With myChart.Axis(AXIS_X) .Format = "DMMM-yy" (I've also tries .Format = "MMM-yy".) .STEP = 1 .GridColor = vbBlack .TitleFont.Bold = True .LabelAngle = 90 End With The date is displaying as a straight short date and I need it to display using a "MON-YY" format. I believe I am following the guidelines set out in the API documentation. Does anyone know why this isn't working? Thanks! Darrin Quote Link to comment Share on other sites More sharing options...
Software FX Posted June 20, 2002 Report Share Posted June 20, 2002 I tried you exact code on a Default chart and it works as expected, I see dates with the right format. It seems that you are overriding this later on in your program. Here are some suggestions: 1) Are you passing data to the chart through data-binding ?. If so, make sure to assign the format BEFORE the data is read. 2) Are you setting string labels (Legend property). If so, you need to format these labels yourself as they are strings. -- FP Software FX, Inc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.