BuyLog In
Ticket Q510691
Visible to All Users

Create the cumulative chart and strange legend format.

created 12 years ago

Hi.
I have some date in the PivotControl.
Period | Income
1-Mon | 100
2-Tue | 100
3-Wed | 50
4-Thu | 50
5-Fri | 200
6-Sat | 300
7-Sun | 400
where Period has the Value format DateTime "d-ddd".
I get http://screencast.com/t/06GB44MFz
First question, Why X axis is has such strange legend?
Is it possible to create cumulative chart? I mean I'd like to see 100, 200 (100 + 100), 250 (100 + 100 + 50), 300, 500, 800, 1200 on the Y axis.
Thanks in advance.

Comments (1)
DevExpress Support Team 12 years ago

    It is not quite clear to me why chart shows data in that format. Perhaps you are using TimeSpan values in the Period field instead DateTime? Would you please provide a small sample project to illustrate this behavior?

    Sign in to comment on this post

    Answers approved by DevExpress Support

    created 12 years ago (modified 12 years ago)

    >>Is it possible to create cumulative chart? I mean I'd like to see 100, 200 (100 + 100), 250 (100 + 100 + 50), 300, 500, 800, 1200 on the Y axis.
    To show values summarized in the PivotGridControl, use the RunningTotal functionality. If you wish to show values summarized only in the ChartControl, handle the PivotGridControl.CustomChartDataSourceRows event. In this event handler, you can calculate summarized values manually and provide these values for the ChartControl. Attached is a small sample project that illustrates this approach.

      Show previous comments (3)
      DevExpress Support Team 12 years ago

        Use the Series.CrosshairLabelPattern property to customize this text. For example, you can use the following pattern - "{A} : {V:N2}".

        DK DK
        Den K 12 years ago

          Thanks. Yes that works correctly but only for CrosshairLabel.
          For marker visible label I have to use Series.Label.PointOptions.ValueNumericOptions.

          DevExpress Support Team 12 years ago

            Thank you for letting us know that the issue has been resolved. We are glad to hear that you have found a solution for this task.

            Sign in to comment on this post

            Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

            Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.