Looking for the correct syntax to change the horizontal axis type from the default "Automatic" to "Text". I have a chart that points to data on various sheets within an excel workbook. The data is pulled however, the X Axis column that it points to is in a data format. The data format is "[$-409]m/d/yy h:mm:ss AM/PM;@". When the data is displayed using the default format it only shows the days and not the hours/minutes/seconds. If I change the format to Text it displays properly...the goal is to do this through a macro so when the data is updated the graph is also updated and displays properly. Thoughts? I have been looking at the VBA reference WIKI but cannot seem to get the right syntax down.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
