User (Legacy) Posted October 20, 2003 Report Share Posted October 20, 2003 Hi: I have created weekly chart that display's date on Monday of each week during the year and labled as e.g x/y/2001(each Monday of 2001 along X-Axis). However, I want to display month name instead of date. i.e. divide x-axis and labled with 12 months instead of 53 week dates. As you see in attached chart, instead I want to display monthname along x-axis in weekly plot. Is there any way to change this? Please reply. Thanks. Shailesh Link to comment Share on other sites More sharing options...
Software FX Posted October 20, 2003 Report Share Posted October 20, 2003 I don't understand what you want to do. 1) You want to display a label every month ? in what format ? 2) I see that this is a an X/Y chart but the Dates are not used as X-Values but as String Labels instead. You may want to use the dates as X-Values and use a Date format in the X-Axis, this way you can go by month and display the dates using any custom Date Format like Month, day. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 21, 2003 Author Report Share Posted October 21, 2003 In my chart, I plot 53 points of the year along X-axis. At present I mark 53 lables along x-axis and that lable is monday date of every week during the year. Instead of that, I want to display name of 12 months i.e. 12 evenly distant lables along x-axis eventhough there are 53 week x-axis points. Please, let me know how to manipulate this display. Thank you. Shailesh "SoftwareFX Support" <support@softwarefx.com> wrote in message news:r0l4JP0lDHA.1156@WEBSERVER1... > I don't understand what you want to do. > > 1) You want to display a label every month ? in what format ? > > 2) I see that this is a an X/Y chart but the Dates are not used as X-Values > but as String Labels instead. You may want to use the dates as X-Values and > use a Date format in the X-Axis, this way you can go by month and display > the dates using any custom Date Format like Month, day. > > -- > FP > Software FX, Inc. > > Link to comment Share on other sites More sharing options...
Software FX Posted October 21, 2003 Report Share Posted October 21, 2003 The labels you are currently setting are just strings. There is no intrinsic value associated with them. You can assign any string you want and you can use the Step property in the X-Axis to control how often the labels are displayed. If you are passing a recordset to Chart FX, you can use the X-Axis format (chart.Axis(AXIS_X).Format) to determine how dates are going to be converted to string labels. You may still want to consider point 2) in my previous post: > 2) I see that this is a an X/Y chart but the Dates are not used as X-Values > but as String Labels instead. You may want to use the dates as X-Values and > use a Date format in the X-Axis, this way you can go by month and display > the dates using any custom Date Format like Month, day. If instead of strings, dates are passed as numerical dates, you can change the format of the labels AFTER the data is passed. If you convert the dates to strings (as you are doing now) they will remain formatted the way they were when they got converted. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.