blocks|key|1825396|text|好了，我终于设法使用Chart.Customize事件在图表上放置了自定义标签。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1825397|以下是我在此图表中使用的数据：|1825398|Vendeur+++++%7C+++Total++++%7C++++idDepartement+++%7C+++idEmploye+++%7C+TotalLastYear
Ghislain++++++++5256.30+++++++1+++++++++++++++++++56++++++++++++++++0.00
Kim++++++++++++12568.42+++++++1++++++++++++++++++++1++++++++++++74719.18
Philippe+++++++17565.27+++++++1+++++++++++++++++++44++++++++++++38454.85|code-block|syntax|javascript|1825399|我将X轴XValueType更改为Double，并将XValueMember更改为idEmploye。|1825400|Result|1825401|正如您所看到的，在图表上显示员工id对用户不是很友好。这就是Customize事件有用的地方。|1825402|下面是我的活动：|1825403|private+void+chart1_Customize(object+sender,+EventArgs+e)
++++{
++++++++//+Set+X+axis+interval+to+1,+label+will+be+centered+(between+0.5+and+1.5)
++++++++chart1.ChartAreas[0].AxisX.Interval+=+1;
++++++++double+startOffset+=+0.5;
++++++++double+endOffset+=+1.5;

++++++++chart1.ChartAreas[0].AxisX.CustomLabels.Clear();

++++++++//+Cycle+through+chart+Datapoints+in+first+serie
++++++++foreach+(System.Windows.Forms.DataVisualization.Charting.DataPoint+pt+in+chart1.Series[0].Points)
++++++++{

++++++++++++//+First+get+the+dataset+used+for+the+chart+(from+its+bindingsource)
++++++++++++DataSet+dsSales+=+(DataSet)bsViewVentesParUtilisateurSignsMoisCourant.DataSource;

++++++++++++//+Second+get+the+datatable+from+that+dataset+based+on+the+datamember+
++++++++++++//+property+of+the+bindingsource
++++++++++++DataTable+dtSales+=+(DataTable)dsSales.Tables[bsViewVentesParUtilisateurSignsMoisCourant.DataMember];

++++++++++++//+Get+a+dataview+and+filter+its+result+based+on+the+current+point's+XValue
++++++++++++DataView+dv+=+new+DataView(dtSales);
++++++++++++dv.RowFilter+=+"idEmploye="+%2B+pt.XValue.ToString();

++++++++++++//+Get+the+"Salesperson"+(or+"Vendeur")+column+value+from+the+first+result
++++++++++++//+(other+rows+will+have+the+same+value+but+row+0+is+safe)
++++++++++++string+firstname+=+dv.ToTable().Rows[0].Field<string>("Vendeur").ToString();

++++++++++++//+Create+new+customlabel+and+add+it+to+the+X+axis
++++++++++++CustomLabel+salespersonLabel+=+new+CustomLabel(startOffset,+endOffset,+firstname,+0,+LabelMarkStyle.None);
++++++++++++chart1.ChartAreas[0].AxisX.CustomLabels.Add(salespersonLabel);
++++++++++++startOffset+%2B=+1;
++++++++++++endOffset+%2B=+1;
++++++++}
++++}|1825404|Final+result|1825405|我对这个结果非常满意。现在，当我双击图表中的条形图时，我可以从X值中获取员工id并生成代码，以获得该人员在给定月份的详细销售报告。|1825406|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/s1lKc.png|1|https://i.stack.imgur.com/NIqZQ.png^0|A|F|0|0|0|4|A|H|6|Q|C|0|0|6|0|0|0|0|0|0|C|1|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1D|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1E|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1F|8|@$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]|$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1M|8|@]|D|@$9|1N|A|1O|1|1P]]|E|$]]|$1|Q|3|R|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1R|8|@]|D|@]|E|$]]|$1|U|3|V|5|J|7|1S|8|@]|D|@]|E|$K|L]]|$1|W|3|X|5|6|7|1T|8|@]|D|@$9|1U|A|1V|1|1W]]|E|$]]|$1|Y|3|Z|5|6|7|1X|8|@]|D|@]|E|$]]|$1|10|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|11|$12|$5|13|14|15|E|$16|17]]|18|$5|13|14|15|E|$16|19]]]]

OK so I finally managed to put custom labels on the chart using the <code>Chart.Customize</code> event.

Here is the data I am using for this chart:

<pre><code>Vendeur | Total | idDepartement | idEmploye | TotalLastYear
Ghislain 5256.30 1 56 0.00
Kim 12568.42 1 1 74719.18
Philippe 17565.27 1 44 38454.85
</code></pre>

I changed X axis <code>XValueType</code> to <code>Double</code>, and the <code>XValueMember</code> to idEmploye.

<a href="https://i.stack.imgur.com/s1lKc.png" rel="nofollow noreferrer">Result</a>

As you can see, it's not very user friendly to have employee id's on a chart. This is where the Customize event gets useful.

Here is my event:

<pre><code>private void chart1_Customize(object sender, EventArgs e)
 {
 // Set X axis interval to 1, label will be centered (between 0.5 and 1.5)
 chart1.ChartAreas[0].AxisX.Interval = 1;
 double startOffset = 0.5;
 double endOffset = 1.5;

 chart1.ChartAreas[0].AxisX.CustomLabels.Clear();

 // Cycle through chart Datapoints in first serie
 foreach (System.Windows.Forms.DataVisualization.Charting.DataPoint pt in chart1.Series[0].Points)
 {

 // First get the dataset used for the chart (from its bindingsource)
 DataSet dsSales = (DataSet)bsViewVentesParUtilisateurSignsMoisCourant.DataSource;

 // Second get the datatable from that dataset based on the datamember 
 // property of the bindingsource
 DataTable dtSales = (DataTable)dsSales.Tables[bsViewVentesParUtilisateurSignsMoisCourant.DataMember];

 // Get a dataview and filter its result based on the current point's XValue
 DataView dv = new DataView(dtSales);
 dv.RowFilter = "idEmploye=" + pt.XValue.ToString();

 // Get the "Salesperson" (or "Vendeur") column value from the first result
 // (other rows will have the same value but row 0 is safe)
 string firstname = dv.ToTable().Rows[0].Field&lt;string&gt;("Vendeur").ToString();

 // Create new customlabel and add it to the X axis
 CustomLabel salespersonLabel = new CustomLabel(startOffset, endOffset, firstname, 0, LabelMarkStyle.None);
 chart1.ChartAreas[0].AxisX.CustomLabels.Add(salespersonLabel);
 startOffset += 1;
 endOffset += 1;
 }
 }
</code></pre>

<a href="https://i.stack.imgur.com/NIqZQ.png" rel="nofollow noreferrer">Final result</a>

I am very happy with the result. And now when I double-click on a bar in the chart, I can get the employee id from the X value and generate the code to get the detailed sales report for that person for the given month.

I have a horizontally stacked bar chart in my app, and I'm trying to figure out how to get the X axis value when the user clicks on a bar. The problem is when I look at the values at runtime, the Y values are fine but the X values are all 0. 

<a href="https://i.stack.imgur.com/RcU3g.png" rel="nofollow noreferrer">Screen capture</a>

In the image above, light blue bars are from <code>Series[0]</code> and represent the MTD sales and the darker ones from <code>Series[1]</code> represent last year's sales for the same month. My goal is that when the user double-clicks on a bar, he is taken to the detailed sales report for that salesperson. 

I haven't tried switching my chart to a regular bar chart because this is what I will need to look like in the end. But I'm starting to wonder if the reason I'm getting all 0's in the <code>XValue</code> field is because of this or because I am using strings as the type of value.

Has anyone ever encountered this or have any clues as to how to fix it?

<a href="https://i.stack.imgur.com/BoQiV.jpg" rel="nofollow noreferrer">Screen capture of points at runtime</a>

C# Chart control : X value of a horizontal bar chart is 0 for all points in the serie

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我的应用程序中有一个水平堆叠的条形图，我正在尝试弄清楚当用户单击条形图时如何获得X轴值。问题是，当我在运行时查看这些值时，Y值很好，但X值都是0。在上图中，浅蓝色条来自Series[0]，代表MTD销售额，来自Series[1]的深蓝色条代表去年同月的销售额。我的目标是，当用户双击条形图时，他会被带到该销售人员的详细销...

C#图表控件:对于系列中所有点，水平条形图的X值为0-腾讯云开发者社区-腾讯云

问C#图表控件:对于系列中所有点，水平条形图的X值为0
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#图表控件:对于系列中所有点，水平条形图的X值为0EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#图表控件:对于系列中所有点，水平条形图的X值为0
EN