Hi, I am trying to create a Sales Pipeline Funnel Chart. What I've got are 4 Sales stages. The funnel chart should always be ordered by the order of the stages: Stage 0, Stage 1, Stage 2, Stage 3. What happens is that since stage 3 has more volume than stage 2, the order I get is Stage 0, Stage 1, Stage 3, Stage 2.
I found the SortStyle.Ascending property, but really what I want is to sort by X Axis (Sales Stage) not Y Axis (volume). Is this possible?
Hello David,
The funnel chart is going to automatically order the data items based on the ascending or descending values assigned to the ValueMemberPath regardless of order listed in the backend. If you want to override the order you could add another numeric property to your data item based (eg. ID) used as the ValueMemberPath in your application so they appear in the order independent from the volume.
Let me know if you have any questions.
Sincerely,
Michael Di FilippoAssociate Software DeveloperInfragistics, Inc.www.infragistics.com/support
I am trying to accomplish the exact same thing as David and am running into the same problem. I cannot figure out how to sort the funnel by the stage number, not the sales amount. I am not able to find the ValueMemberPath property on the chart control. I am using the UltraChart control in version 19.1. Can you give me a more detailed explanation of how to do this? I am using VB.net
You would need to migrate to our newer UltraFunnelChart. https://es.infragistics.com/help/winforms/funnelchart-data-binding
I gave the new funnel chart a shot and like the new data binding. However, I feel like the display of the chart is a step back. My current funnel chart is 3D and in my opinion, looks much better than the new one:
I couldn't seem to locate much in the way of sample VB code for customizing the appearance of the new funnel chart. Can you point me in the right direction? I would much rather stick with my current chart if I could find a way to sort it by sales stage.
Hello Richard,
The XamFunnelChart supports the Bezier Curve. Although with our samples I couldn't get it quite like your setup on the left. I would test our "Use Bezier Curve" sample in our Samples browser.