Visual Studio .NET Chart控件单数据源行堆叠柱形图显示异常求助

问题核心 #

当数据源仅包含一行DATE类型的MYDATE数据时，3个堆叠柱形系列显示异常；若MYDATE改为字符串类型，堆叠显示正常但X轴无标签。

解决思路及方案 #

1. 强制X轴为分类轴模式

默认情况下，Chart控件会将DATE类型识别为数值（连续）轴，单行日期会被当作连续轴上的单个点，导致三个系列分散显示。需强制切换为分类轴：

Me.Chart1.ChartAreas(0).AxisX.Interval = 1
Me.Chart1.ChartAreas(0).AxisX.IsLabelAutoFit = True
Me.Chart1.ChartAreas(0).AxisX.LabelStyle.Format = "yyyy-MM-dd"
Me.Chart1.ChartAreas(0).AxisX.IntervalType = DateTimeIntervalType.NotSet
Me.Chart1.ChartAreas(0).AxisX.LabelStyle.IsEndLabelVisible = True

2. 调整数据绑定顺序

原代码先绑定数据源再添加系列，可能触发控件初始化逻辑异常。需先创建并配置所有系列，再绑定数据源，修改Form5_Load方法如下：

Private Sub Form5_Load(sender As Object, e As EventArgs) Handles Me.Load
    '// 先创建并配置所有系列
    #Region "Series Liabilities"
    Dim Liabilities As Series = New Series("Liabilities")
    Me.Chart1.Series.Add(Liabilities)
    Me.Chart1.Series("Liabilities").ChartType = SeriesChartType.StackedColumn
    Me.Chart1.Series("Liabilities").XValueMember = "MYDATE"
    Me.Chart1.Series("Liabilities").YValueMembers = "LIABILITIES"
    #End Region

    #Region "Series Margin"
    Dim Margin_Interest As Series = New Series("Margin")
    Me.Chart1.Series.Add(Margin_Interest)
    Me.Chart1.Series("Margin").ChartType = SeriesChartType.StackedColumn
    Me.Chart1.Series("Margin").XValueMember = "MYDATE"
    Me.Chart1.Series("Margin").YValueMembers = "MARGIN"
    #End Region

    #Region "Series Net Interest"
    Dim NET_INTEREST As Series = New Series("Net Interest")
    Me.Chart1.Series.Add(NET_INTEREST)
    Me.Chart1.Series("Net Interest").ChartType = SeriesChartType.StackedColumn
    Me.Chart1.Series("Net Interest").XValueMember = "MYDATE"
    Me.Chart1.Series("Net Interest").YValueMembers = "NET_INTEREST"
    #End Region

    '// 加载数据
    Dim dt As New DataTable
    Using cn = New SqlClient.SqlConnection
        cn.ConnectionString = ConnectionString
        cn.Open()
        Using cmd = cn.CreateCommand
            cmd.CommandText = "SELECT MYDATE,SUM(LIABILITIES) AS LIABILITIES, 
                               SUM(MARGIN) AS MARGIN,
                               SUM(NET_INTEREST) AS NET_INTEREST
                               FROM CHART 
                               GROUP BY MYDATE
                               ORDER BY MYDATE
                               "
            Using adap As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(cmd)
                adap.Fill(dt)
            End Using
        End Using
    End Using

    '// 绑定数据源
    Me.Chart1.DataSource = dt
    Me.Chart1.DataBind()

    '// 配置X轴
    Me.Chart1.ChartAreas(0).AxisX.Interval = 1
    Me.Chart1.ChartAreas(0).AxisX.IsLabelAutoFit = True
    Me.Chart1.ChartAreas(0).AxisX.LabelStyle.Format = "yyyy-MM-dd"
    Me.Chart1.ChartAreas(0).AxisX.IntervalType = DateTimeIntervalType.NotSet
End Sub

3. 修复字符串类型MYDATE的X轴标签问题

若使用字符串类型的MYDATE，需确保标签正常显示：

• 查询时格式化日期为明确字符串格式，例如：CONVERT(VARCHAR, MYDATE, 23)
• 强制开启标签可见：

Me.Chart1.ChartAreas(0).AxisX.LabelStyle.Enabled = True

原理说明 #

• 单日期值下，连续轴模式会错误将三个系列的X值视为分散点；切换为分类轴后，所有系列归属于同一分类标签，实现正常堆叠。
• 先配置系列再绑定数据源，确保控件正确关联系列与数据源字段，避免初始化顺序导致的绑定异常。

内容的提问来源于stack exchange，提问作者sickboy