vb.net 并非所有 Xaxis 标签都显示在来自绑定数据集的图表控件上

Not All Xaxis Labels Showing On Chart Control From Bound Dataset

提问by Riples

I have a problem with a couple of various chart controls that I am trying to bind to different datasets. Basically, when I run the following query, my chart control will only show every 2nd Label on the X Axis no matter what size I make the chart.

我在尝试绑定到不同数据集的几个各种图表控件时遇到问题。基本上，当我运行以下查询时，无论我制作的图表大小如何，我的图表控件都只会显示 X 轴上的每个第二个标签。

SELECT MID(MONTHNAME(created_at),1,3) as Month, COUNT(created_at) AS TotalCreatedCalls, COUNT(closed_at) AS TotalClosedCalls FROM call_detail WHERE DATE(created_at) BETWEEN DATE_SUB(CURDATE(), INTERVAL 12 MONTH) AND CURDATE() GROUP BY MONTH(created_at)

However, if I remove the MONTHNAME statement and just return the MONTH, all 12 months appear fine on the X Axis Label as numbers.

但是，如果我删除 MONTHNAME 语句并只返回 MONTH，则所有 12 个月在 X 轴标签上都显示为数字。

SELECT MONTH(created_at) as Month, COUNT(created_at) AS TotalCreatedCalls, COUNT(closed_at) AS TotalClosedCalls FROM call_detail WHERE DATE(created_at) BETWEEN DATE_SUB(CURDATE(), INTERVAL 12 MONTH) AND CURDATE() GROUP BY MONTH(created_at)

I have the same exact issue with another chart control where I am trying to show peoples names along the X Axis, but I only get every 5th name. However, I also have another chart control with pulls 7 days and shows the week name on the X Axis and that seems to work fine.

我在另一个图表控件上有同样的问题，我试图在 X 轴上显示人们的名字，但我只得到每第 5 个名字。但是，我还有另一个图表控件，可以拉 7 天并在 X 轴上显示周名称，这似乎工作正常。

回答by Manojbabu

Add this code it will help you

添加此代码它将帮助您

chart1.ChartAreas(0).AxisX.Interval = 1

chart1.ChartAreas(0).AxisX.Interval = 1

回答by Riples

I found the answer to my question at the following site HERE

我找到了答案，我的问题在以下网站HERE

It had to do with the Minor and Major ticks of the Axis LabelStyles and it just required some playing around and tweaking to give my the results I needed.

它与 Axis LabelStyles 的 Minor 和 Major 刻度有关，它只需要进行一些操作和调整即可获得我需要的结果。