在DataVisualization.Charting.Chart的两个Y轴上对齐零

Question

我有两个DataVisualization.Charting.Chart系列和两个AxisY (AxisY1和AxisY2)。我能够在图表上绘制这两个系列，但是左轴和右轴的零没有对齐。如何对齐两个轴的零？

NetChart.Series.Clear()
NetChart.Series.Add("Net")
NetChart.Series.Add("Net Cum.")
NetChart.Series(0).Points.Clear()
NetChart.Series(1).Points.Clear()

Dim netSaleDT As DataTable = SomeDataTable
netSaleDT.Columns.Add("CumulativeNet", GetType(Decimal))
Dim index As Integer = 0
Dim cumulSum As Decimal = 0
For Each drow As DataRow In netSaleDT.Rows
     cumulSum += Convert.ToDecimal(drow("Net"))
     drow("CumulativeNet") = cumulSum
     NetChart.Series(0).Points.AddXY(drow("myMonth"), Convert.ToDecimal(drow("Net")))
     NetChart.Series(1).Points.AddXY(drow("myMonth"), Convert.ToDecimal(drow("CumulativeNet")))
     NetChart.Series(0).Points(index).AxisLabel = drow("myMonth")
     index += 1
Next

NetChart.Series(0).YAxisType = System.Windows.Forms.DataVisualization.Charting.AxisType.Primary
NetChart.Series(1).YAxisType = System.Windows.Forms.DataVisualization.Charting.AxisType.Secondary
NetChart.Series(1).ChartType = DataVisualization.Charting.SeriesChartType.Line
NetChart.ChartAreas(0).AxisX.Interval = 2
NetChart.ChartAreas(0).AxisY.LabelStyle.Format = "C"
NetChart.ChartAreas(0).AxisY2.LabelStyle.Format = "C"

NetChart.Series(1).BorderWidth = 2
NetChart.Series(1).Color = Color.Blue
NetChart.ChartAreas(0).AxisY2.Enabled = DataVisualization.Charting.AxisEnabled.True
NetChart.ChartAreas(0).AxisY2.LabelStyle.Enabled = True

Answer 1

轴属性是否设置为auto？

如果是，则需要通过编程手动设置每个轴。

http://msdn.microsoft.com/en-us/library/system.windows.forms.datavisualization.charting.axis.minimum%28v=vs.110%29.aspx

当我设置最小/最大值时，我通常会这样做：

        Dim myChart As Excel.ChartObject = CType(xlCharts.Item(y), ChartObject)
        Dim chartPage As Excel.Chart = myChart.Chart
        chartPage.Axes(Excel.XlAxisType.xlCategory).minimumscale = minimum
        chartPage.Axes(Excel.XlAxisType.xlCategory).maximumscale = maximum

这将更改x轴比例，以更改Y比例：

http://msdn.microsoft.com/en-us/library/system.windows.forms.datavisualization.charting.chartarea.axisy%28v=vs.110%29.aspx

并更改辅助y刻度：

http://msdn.microsoft.com/en-us/library/system.windows.forms.datavisualization.charting.chartarea.axisy2%28v=vs.110%29.aspx

希望这能有所帮助

*编辑

我试着不给你完整的答案

但我想：

    Dim myChart As Excel.ChartObject = CType(QoE.xLSheet1.ChartObjects(0), ChartObject)
    Dim chartPage As Excel.Chart = myChart.Chart
    chartPage.Axes(Excel.XlAxisGroup.xlPrimary).minimumscale = 0
    chartPage.Axes(Excel.XlAxisGroup.xlSecondary).minimumscale = 0

将图表对象设置为您要更改的任何图表，然后将主y轴和次y轴都设置为0