Hotspot tool and axis label formatting
Posted: Thu Dec 04, 2008 5:12 pm
Hi,
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:
and I changed the style of the hotspot tool to Label and Value, which whilst it works for the tooltip (i.e. the X value is displayed in the required format), the labels on the bottom axis also change (i.e. the time is also included). Basically I'd like the hotspot tool tips to include the time but not have the time displayed on the labels for the bottom axis.
Thanks
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