BuyLog In
Ticket Q510382
Visible to All Users

Pivot Control and Chart: print the chart, show the chart where line for the each column.

created 12 years ago

HI.
I have the PivotControl which have two DataArea fields: plan and fact. One RowArea field: product. One ColumnArea field: data (twelve month of year).
Is it possible to print the chart?
When I select one row I get one line http://screencast.com/t/6Y1oAL1H9, where 24 position on the X axis.
1,3,5,…,23 position from Plan column.
2,4,6,…,24 position from Fact column.
But I'd like to get two lines. Where first line is for the Plan column and second is for the Fact column. And only 12 position.
Is it possible?
If I have 3 columns is it possible exclude any from the chart?

Thanks in advance.

Sign in to comment on this post

Answers approved by DevExpress Support

created 12 years ago (modified 12 years ago)

To accomplish this task, place data fields into the Row Area by setting the PivotGrid.OptionsDataField.Area property to RowArea.

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

      I have updated this sample. There is no easy way to display one pivot row as two series in the Chart control. So, I suggest that you change the fields' layout in the Pivot as described in the sample. With this project, you can select two columns (for example, Product A-Price and Product A-Price(avg)) to display the necessary series.

      DK DK
      Den K 12 years ago

        Strange. Because John said
        >>Attached is a small sample project that illustrates how to customize PivotGrid layout, so that ChartControl automatically >>creates two series when a row is selected.
        Unfortunately, I can not change layout of fields. And your example can't help me.
        Also I didn't get an answer on question "How to exclude information about any columns from the chart when I select one row?"
        In your example I set pivotControl.OptionsChartDataSource.ProvideDataByColumns = false
        First case) I select one row (day in the example) and I'd like to see one series only for the Price columns without hiding the Price(avg) columns. Exclude Price(avg) arguments and values from the chart.
        Second case) I select one row and I'd like to see two series for the Price and for the Price(avg) columns.
        I tried to do that but I couldn't find the CustomChartDataSourceColumns event like CustomChartDataSourceRows.
        Is is possible? May be exist some custom event?
        Thanks in advance.

        DevExpress Support Team 12 years ago

          You will find helpful information on how to accomplish this task in the How to highlight pivot cells that correspond to a series point under the mouse pointer example.

          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.