Replies
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.
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 = ""
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 = " "
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 = ""
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 = ""
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 = ""
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 = " "
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 = ""
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.
Hi Hristo
Sorry, I'm a bit confused, why is it introducing a difference? Is that because the server and client are in different timezones, or is there some other reason?
Thanks, Tom
