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
Thanks for this answer. SortStyle.None appears to be doing what I want. If this doesn't work I'll investigate ValueMemberPath