I need help with a Telerik stacked bar chart.
I have used a separate data source to get the data. Moreover, I'm passing in parameter values to get the chart which is absolutely working fine.
I have 4 columns in my table. With Column "A" as X-axis which is to be grouped and "TaskTime" as Y-axis.
I have to display column "Tasktime" again in the chart with the label names of column "B" and "C" on them. And the length of the stacked bar should vary according to the "TaskTime". I hope you will have a better understanding if you look at the attached files.I'm expected to produce a chart exactly or almost similar to the "Expected" Chart that I have attached.
I have attached two files where one is the "Expected" chart and the other one is the "Resulted" chart which was obtained so far. I have made changes to the data of the " Expected" chart to help you understand better(since the "Resulted" data is not that good for understanding). I have also attached my piece of code for your reference. I managed to produce a chart slightly similar to the "Expected" one. But, I am struck halfway and I don't have any clue how to proceed further. So, I request you to help me.
The issues to be sorted out in the "Resulted" chart are
- The X-Axis values should be grouped.
- The stacked bar should be differentiated in their colour.
- Make the column values of "B and C" appear on their respective "TaskTime" bars in the format "B-C".
- Show the sum of the "TaskTime" values appear on the top of their respective bars in case of any stacked bars or just their values.
I would be glad if this chart can be done in Telerik report chart (Without using Radchart). But, if not possible, I wouldn't mind switching over to Radchart. But, I wanted to get this chart done, somehow. I would be really grateful if you could help me to proceed further. Thank you!!!
Partial Public Class Report1
Public Sub New()
Private Sub Report1_NeedDataSource(sender As System.Object, e As System.EventArgs) Handles MyBase.NeedDataSource
Dim ttasktime As New tasktime
Dim tasktime As New Telerik.Reporting.Charting.ChartSeries("tasktime")
tasktime.DataYColumn = "tasktime"
tasktime.Name = "tasktime"
tasktime.DataLabelsColumn = "B"
tasktime.DataXColumn = "A"
tasktime.Type = Charting.ChartSeriesType.StackedBar
Chart1.PlotArea.XAxis.DataLabelsColumn = "A"
Chart1.DataSource = ttasktime