Hi, i have a chart which normally has a x axis with a date value.
Under certain circumstances, I'd like to group the results and show the monthly accumulated values, and show the month name
In the data I have both a date field and a month field, and I can easily group by the month field, but I can't seem to format it so that it show the month name rather than the month value.
Can you please point me in the right direction?
This is what I have so far:
Private Sub chart1_ItemDataBinding(ByVal sender As Object, ByVal e As EventArgs) Handles Chart1.ItemDataBinding
Chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = -90
If Me.ReportParameters("Time").Value.ToString.Trim = "Daily" Then
Chart1.PlotArea.XAxis.DataLabelsColumn = "userlogdate"
ElseIf Me.ReportParameters("Time").Value.ToString.Trim = "Yearly" Then
Chart1.PlotArea.XAxis.DataLabelsColumn = "year"
Chart1.DataGroupColumn = "year"
ElseIf Me.ReportParameters("Time").Value.ToString.Trim = "Monthly" Then
Chart1.DataGroupColumn = "month"
Chart1.PlotArea.XAxis.DataLabelsColumn = "month"
Chart1.PlotArea.XAxis.Appearance.ValueFormat = Charting.Styles.ChartValueFormat.ShortDate
Chart1.PlotArea.XAxis.Appearance.CustomFormat = ???
Thanks for you help