Is it possible to have different format labels for the bottom axis and for individual points when using the hotspot tool?
I have a time series on my chart and by default the labels on the bottom axis are displayed in the format MM/dd/yyyy (which is fine). When I add a hotspot tool and set the style to "X and Y" the X values are also displayed in the same format. Is it possible for them to be displayed in the fomat MM/dd/yyyy HH:mm:ss without affecting the axis labels?
I tried adding a text value for each of my points as I was adding them, for example:
Code: Select all
' third parameter is label
For i As Integer = 0 To 999
series.Add(today.AddDays(-i), i * 10, Format(today.AddDays(-i), "MM/dd/yyyy HH:mm:ss"))
Next
Thanks