Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
523
Custom x-axis labels
posted

Hi,

  I have a small problem, I have a series of data from 1990 to 2008, with each year contains 12 months of record. so my data looks like

1990 01 100

1990 02  125

..... so on

2008 12 300

 

but I want to display in the line chart only the years like 1990 , 1991.....2008 on x-axis. and also year should not repeat. Currently I am getting for each year I am getting twelve number of Year points on x-axis. I know I can sum this data and take an average and put that data for that year from SQL side, but I dont want to do that. Please help me out here 

 

  • 26458
    Offline posted

    Try setting these properties on the x axis:
    TickmarkStyle = AxisTickStyle.DataInterval
    TickmarkInterval = 1
    TickmarkIntervalType = AxisIntervalType.Years

    If your x axis uses date time values then you should see one label for each year.