Regarding combination of two charts

Hello Everyone,

Can someone please help me in combining a line and bar chart. 

Thanks 

Poorvi

Hello Poorvi, 

You can try the flowing link: 

https://success.outsystems.com/Documentation/Development_FAQs/How_to_combine_a_line_graph_with_a_bar_chart

The screenshots are not complete consistent but all the steps are there. I just followed the steps: 


With this as result: 


Obviously this works with 6 hardcoded datapoints and for a real solution you need some tweaking. 




Hey,

If you are using OutSystems 11 check out the "Combine two different chart types" section of the Advanced Charts customization documentation page.

Cheers

I am using Highcharts.... I need to import data from excel's... But i am not sure  how to feed data to series ...Please help.  Please tell me where i am going wrong

SyntaxEditor Code Snippet

AdvancedFormat_Init(DataPointFormats:,DataSeriesFormats:,XAxisJSON:,YAxisJSON:,HighchartsJSON:
"
 data: {
        table: GetTotaldaysales
    },
plotOptions: { series: { dataLabels: {  enabled: true  }  }  },
xAxis: [{
        categories: GetTotaldaysales.List.Current.Totaldaysale.Date,
        crosshair: true
    }],
  yAxis: [{ // Primary yAxis
        labels: {
            format: '{value}',
            style: {
                color: Highcharts.getOptions().colors[1]
            }
        },
        title: {
            text: 'Sales',
            style: {
                color: Highcharts.getOptions().colors[1]
            }
        }
    }, { // Secondary yAxis
        title: {
            text: 'Target',
            style: {
                color: Highcharts.getOptions().colors[0]
            }
        },
        labels: {
            format: '{value}',
            style: {
                color: Highcharts.getOptions().colors[0]
            }
        },
        opposite: true
    }],
    series: [{
        name: 'Target',
        type: 'column',
        yAxis: 1,
        data: GetTotaldaysales.List.Current.Totaldaysale.Target,
        tooltip: {
            valueSuffix: ''
        }

    }, {
        name: 'Sales',
        type: 'spline',
        data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6],
        tooltip: {
            valueSuffix: ''
        }
    }]

"
)

Erik Brzozowski wrote:

Hello Poorvi, 

You can try the flowing link: 

https://success.outsystems.com/Documentation/Development_FAQs/How_to_combine_a_line_graph_with_a_bar_chart

The screenshots are not complete consistent but all the steps are there. I just followed the steps: 


With this as result: 


Obviously this works with 6 hardcoded datapoints and for a real solution you need some tweaking. 




hi,

I am also working on this.

I thought i had everything right but i don't get the desired result.

Is it possible that you can send an OML from the example combine column and line Chart?


(I use OS 11)


Thanks