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
290
Columnchart with Y and Y2 Axis
posted

Hi,

i am trying to build a chart with 2 Y-Axes. I am using a ColumnChart and i want that some of the columns are oriented at the left side and some on the right side. Is there any way where i can connect the line to the Axis?

 

Something that looks like that -->

 

i tried something like that

Dim saueleAnzahl1 As New NumericSeries()
                Dim saueleAnzahl2 As New NumericSeries()
                Dim saueleAnzahl3 As New NumericSeries()
                Dim saueleSumme1 As New NumericSeries()
                Dim saueleSumme2 As New NumericSeries()
                Dim saueleSumme3 As New NumericSeries()

                saueleAnzahl1.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(2)), "Anzahl 1 ", False))
                saueleSumme1.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(5)), "Summe 1", False))
                saueleSummeTZ.PEs.Add(New PaintElement(Color.Blue))

                saueleAnzahl2.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(3)), "Anzahl 2", False))
                saueleSumme2.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(6)), "Summe 2", False))
                saueleSummeLPZ.PEs.Add(New PaintElement(Color.Blue))

                saueleAnzahl3.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(4)), "Anzahl 3", False))
                saueleSumme3.Points.Add(New NumericDataPoint(CDbl(dt.Rows(0).Item(7)), "Summe 3", False))
                saueleSummeTZMAX.PEs.Add(New PaintElement(Color.Blue))

                chart.Axis.X.Labels.Visible = False
                chart.Axis.Y2.NumericAxisType = NumericAxisType.Logarithmic
                chart.Axis.Y2.Visible = True
                chart.Axis.Y2.Labels.Visible = True
                chart.Axis.Y.NumericAxisType = NumericAxisType.Linear

                chart.Axis.Y.ChartComponent.Series.Clear()
                chart.Axis.Y2.ChartComponent.Series.Clear()

                .chart.Axis.Y.ChartComponent.Series.AddRange(New ISeries() {saueleAnzahlTZ, saueleAnzahlLPZ, saueleAnzahlTZMAX})
                chart.Axis.Y2.ChartComponent.Series.AddRange(New ISeries() {saueleSummeTZ, saueleSummeLPZ, saueleSummeTZMAX})

 

But i only get two Y-Axes but no connection between the last 3 columns with the second y-axis :-(

I want that the two axes are differently scaled so that i get all what i want to display. At the moment i got another problem that the first Y-Axis starts always with the value "20" but it needs to be "0" at every time.

 

Hope you can help me.

 

Best Regards MO

Parents
No Data
Reply Children
No Data