Hi, I'm trying to recreate a stacked column chart I created in Excel (attached).
It shows individuals contribution to team targets against suppliers. There are 4 members of the team each with different targets against the same supplier.
In the attached example Jane has a target of 8 sales against the supplier Barclaycard. The team target is 21.
Bob: 4, Freddy: 3, Carol: 6
Jane has so far made 5 sales. She has achieved 63% of her individual target calculated as 8 (her target) / 5 (her sales). Her contribution to the team target is proportional to her personal target. In this case she has achieved 16% towards the team target.
Calculated as: (1 / team members) * (sales made / target)
(1/4)*(8/5) = 0.15625 : rounded to 0.16 = 16%
The column for Barclaycard would show the total % the team has achieved against the team target (it could be over 100%) and then Jane would appear as a 16% block within that column.
I don't seem to be able to get the chart to show more than 100% or have the individuals show as their contribution, it converts it to another % based on the whole. Jane appears as 22%. Image attached.
Your help would be very much appreciated. Many thanks.
Target Dashboard.xlsx
Hello Nathan,
Thank you for contacting Infragistics!
I have some questions concerning this matter, How is your data setup, is it already in percentage values? Or is it in the whole numbers? How are you currently setting up the UltraChart? Do you have anything against the use of the UltraDataChart instead?
Hi Mike, thanks for getting back to me.
I can set the data up any way needed. I started with the percentage values as that worked in the Excel example. When the user sees their contribution to the team effort that will need to be seen as a percentage.
So I can do whole or percentage numbers whatever is easiest\works.
I set the UltraChart up using the wizard. The datasoure is a datatable.
This is all the custom code I've written for it.
Dim cbs As New BindingSource cbs.DataSource = targetData _teamTargetUltraChart.DataSource = cbs _teamTargetUltraChart.DataBind() _teamTargetUltraChart.ColumnChart.ColumnSpacing = 1 _teamTargetUltraChart.StackChart.StackStyle = StackStyle.Normal
and this is from the designer:
Me.TeamTargetUltraChart.ChartType = Infragistics.UltraChart.[Shared].Styles.ChartType.StackColumnChart ' 'TeamTargetUltraChart ' Me.VisionControlReadWriteAuthorization.SetApplyAuthorization(Me.TeamTargetUltraChart, false) Me.TeamTargetUltraChart.Axis.BackColor = System.Drawing.Color.FromArgb(CType(CType(255,Byte),Integer), CType(CType(248,Byte),Integer), CType(CType(220,Byte),Integer)) PaintElement1.ElementType = Infragistics.UltraChart.[Shared].Styles.PaintElementType.None PaintElement1.Fill = System.Drawing.Color.FromArgb(CType(CType(255,Byte),Integer), CType(CType(248,Byte),Integer), CType(CType(220,Byte),Integer)) Me.TeamTargetUltraChart.Axis.PE = PaintElement1 Me.TeamTargetUltraChart.Axis.X.Extent = 22 Me.TeamTargetUltraChart.Axis.X.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.X.Labels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.X.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.X.Labels.ItemFormatString = "<ITEM_LABEL>" Me.TeamTargetUltraChart.Axis.X.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.X.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.VerticalLeftFacing Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.X.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.X.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.X.Labels.Visible = true Me.TeamTargetUltraChart.Axis.X.LineThickness = 1 Me.TeamTargetUltraChart.Axis.X.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.X.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.X.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.X.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.X.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.X.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.X.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.X.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.X.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.X.Visible = true Me.TeamTargetUltraChart.Axis.X2.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.X2.Labels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.X2.Labels.HorizontalAlign = System.Drawing.StringAlignment.Far Me.TeamTargetUltraChart.Axis.X2.Labels.ItemFormatString = "<ITEM_LABEL>" Me.TeamTargetUltraChart.Axis.X2.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.X2.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.VerticalLeftFacing Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Far Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.VerticalLeftFacing Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.X2.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.X2.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.X2.Labels.Visible = false Me.TeamTargetUltraChart.Axis.X2.LineThickness = 1 Me.TeamTargetUltraChart.Axis.X2.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.X2.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.X2.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.X2.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.X2.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.X2.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.X2.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.X2.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.X2.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.X2.Visible = false Me.TeamTargetUltraChart.Axis.Y.Extent = 45 Me.TeamTargetUltraChart.Axis.Y.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Y.Labels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.Y.Labels.HorizontalAlign = System.Drawing.StringAlignment.Far Me.TeamTargetUltraChart.Axis.Y.Labels.ItemFormatString = "<DATA_VALUE:P>" Me.TeamTargetUltraChart.Axis.Y.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Y.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.FormatString = "" Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Far Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Y.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.Y.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Y.Labels.Visible = true Me.TeamTargetUltraChart.Axis.Y.LineThickness = 1 Me.TeamTargetUltraChart.Axis.Y.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Y.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.Y.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Y.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.Y.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Y.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.Y.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Y.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.Y.TickmarkInterval = 100R Me.TeamTargetUltraChart.Axis.Y.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.Y.Visible = true Me.TeamTargetUltraChart.Axis.Y2.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Y2.Labels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.Y2.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Y2.Labels.ItemFormatString = "<DATA_VALUE:00.##>" Me.TeamTargetUltraChart.Axis.Y2.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Y2.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.FormatString = "" Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Y2.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.Y2.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Y2.Labels.Visible = false Me.TeamTargetUltraChart.Axis.Y2.LineThickness = 1 Me.TeamTargetUltraChart.Axis.Y2.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Y2.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.Y2.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Y2.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.Y2.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Y2.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.Y2.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Y2.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.Y2.TickmarkInterval = 100R Me.TeamTargetUltraChart.Axis.Y2.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.Y2.Visible = false Me.TeamTargetUltraChart.Axis.Z.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Z.Labels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.Z.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Z.Labels.ItemFormatString = "<ITEM_LABEL>" Me.TeamTargetUltraChart.Axis.Z.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Z.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.FontColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Z.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.Z.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Z.Labels.Visible = false Me.TeamTargetUltraChart.Axis.Z.LineThickness = 1 Me.TeamTargetUltraChart.Axis.Z.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Z.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.Z.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Z.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.Z.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Z.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.Z.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Z.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.Z.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.Z.Visible = false Me.TeamTargetUltraChart.Axis.Z2.Labels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Z2.Labels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.Z2.Labels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Z2.Labels.ItemFormatString = "<ITEM_LABEL>" Me.TeamTargetUltraChart.Axis.Z2.Labels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Z2.Labels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.Font = New System.Drawing.Font("Verdana", 7!) Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.FontColor = System.Drawing.Color.Gray Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.HorizontalAlign = System.Drawing.StringAlignment.Near Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.Layout.Behavior = Infragistics.UltraChart.[Shared].Styles.AxisLabelLayoutBehaviors.[Auto] Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.[Shared].Styles.TextOrientation.Horizontal Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Z2.Labels.SeriesLabels.Visible = true Me.TeamTargetUltraChart.Axis.Z2.Labels.VerticalAlign = System.Drawing.StringAlignment.Center Me.TeamTargetUltraChart.Axis.Z2.Labels.Visible = false Me.TeamTargetUltraChart.Axis.Z2.LineThickness = 1 Me.TeamTargetUltraChart.Axis.Z2.MajorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Z2.MajorGridLines.Color = System.Drawing.Color.Gainsboro Me.TeamTargetUltraChart.Axis.Z2.MajorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Z2.MajorGridLines.Visible = true Me.TeamTargetUltraChart.Axis.Z2.MinorGridLines.AlphaLevel = CType(255,Byte) Me.TeamTargetUltraChart.Axis.Z2.MinorGridLines.Color = System.Drawing.Color.LightGray Me.TeamTargetUltraChart.Axis.Z2.MinorGridLines.DrawStyle = Infragistics.UltraChart.[Shared].Styles.LineDrawStyle.Dot Me.TeamTargetUltraChart.Axis.Z2.MinorGridLines.Visible = false Me.TeamTargetUltraChart.Axis.Z2.TickmarkStyle = Infragistics.UltraChart.[Shared].Styles.AxisTickStyle.Smart Me.TeamTargetUltraChart.Axis.Z2.Visible = false Me.TeamTargetUltraChart.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Center Me.TeamTargetUltraChart.ColorModel.AlphaLevel = CType(150,Byte) Me.TeamTargetUltraChart.ColorModel.ColorBegin = System.Drawing.Color.Pink Me.TeamTargetUltraChart.ColorModel.ColorEnd = System.Drawing.Color.DarkRed Me.TeamTargetUltraChart.ColorModel.ModelStyle = Infragistics.UltraChart.[Shared].Styles.ColorModels.CustomLinear ChartTextAppearance1.ChartTextFont = New System.Drawing.Font("Arial", 7!) ChartTextAppearance1.ClipText = false ChartTextAppearance1.Column = -2 ChartTextAppearance1.ItemFormatString = "<DATA_VALUE:00.00>" ChartTextAppearance1.Row = -2 ChartTextAppearance1.Visible = true ColumnChartAppearance1.ChartText.Add(ChartTextAppearance1) Me.TeamTargetUltraChart.ColumnChart = ColumnChartAppearance1 Me.TeamTargetUltraChart.Dock = System.Windows.Forms.DockStyle.Fill Me.TeamTargetUltraChart.Effects.Effects.Add(GradientEffect1) Me.TeamTargetUltraChart.Legend.Visible = true Me.TeamTargetUltraChart.Location = New System.Drawing.Point(0, 0) Me.TeamTargetUltraChart.Name = "TeamTargetUltraChart" Me.TeamTargetUltraChart.Size = New System.Drawing.Size(590, 345) Me.TeamTargetUltraChart.TabIndex = 4 Me.TeamTargetUltraChart.Tooltips.HighlightFillColor = System.Drawing.Color.DimGray Me.TeamTargetUltraChart.Tooltips.HighlightOutlineColor = System.Drawing.Color.DarkGray
I've not got a preference to which chart, so happy to go with the UltraDataChart if that'll do it.
Many thank again.
Perfect, exactly what I needed. Thanks Mike.
Thank you for your patience and updates. I have discussed this with my team and for what you want it seems you will want to go with the UltraChart, as currently the UltraDataChart doesn’t support value labels on the stacks of the chart. To get the labels to display their individual value instead of percentage of the whole you can see the following forum post.
To get the y axis to go beyond 100% you will want to have your backend values converted to a percentage and then just format the label as a percentage. And on your y axis set your min and max range to the min and max percentages you want.
Hi Mike,
Thank you for helping.
All targets vary. Each person will have their own target per company and so the total target against a company can be different between companies.
I.e.
Bob's targets:
Barclaycard: 5, Unity: 4
Jane's targets:
Barclaycard: 3, Unity: 6
Total for Barclaycard is therefore 8 and Unity 10.
Thank you for the update. I am currently working on creating a sample to demonstrate this behavior. I have some follow up questions. Is the overall target going to be the same for every company/account? Are the individual per person targets all the same for each person, or will different team members have different targets for different companies?