In Excel i can set major units on graphs, is there somehting similar here?
E.g The following graph is showing 31 years (2008 - 2038)
The following is showing 40 years and you will notice the years are missing
Is there a way to show every 3rd year in the x axis?
Does something like this work for you?
ultraChart1.ChartType = ChartType.ColumnChart;
ultraChart1.LineChart.TreatDateTimeAsString = false;
ultraChart1.Data.SwapRowsAndColumns = true;
ultraChart1.Axis.X.Labels.ItemFormat = AxisItemLabelFormat.Custom;
ultraChart1.Axis.X.Labels.ItemFormatString = "<ITEM_LABEL:yyyy>";
ultraChart1.Axis.X.Labels.Orientation = TextOrientation.VerticalLeftFacing;
ultraChart1.Axis.X.TickmarkStyle = AxisTickStyle.DataInterval;
ultraChart1.Axis.X.TickmarkIntervalType = AxisIntervalType.Years;
ultraChart1.Axis.X.TickmarkInterval = 3;
ultraChart1.DataSource = GetSampleColumnData();
ultraChart1.DataBind();
-Graham
That doesn't work but i think its on the right track.
I wanted to show the labels every three years but still render all the data.
I found an axample. I implemented a custom label renderer in order to skip labels
Thanks
You want it to omit the data that doesn't happen on the interval? Or do you only want it to show the labels every three years but still render all the data?
This sample is showing 10 years
I may have up to 40 years of data showing so i want the years and the columns (Tenants, CPI, Outgoings) to only show every 3 years.
I'm still a bit confused by where you are currently and where you are trying to get to from these images and your descriptions, is it possible for you to provide any sample code that is representative of how your chart is currently structured, and describe how you would like it to look?
The above describes how you can adjust the tickmarks on the axes, and was directed at your original question. The other code was just to make it a complete sample and if you merged it all in it may be interfering with other settings you had already established (grouping, etc).
This is the original
This is using the sample code