topic Re: Columns graph and lines graph in the same chart in Application Development and Automation Discussions

Columns graph and lines graph in the same chart

Kartik2 — Mon, 13 Feb 2012 06:45:14 GMT

Dear All,

I want have a requirement to display the required capacity as a columns graph and available capacity as a lines graph. Both the graphs have different data and should appear on the same chart.

Which Class or Function Module shall i use to achieve this ??

Thanks and Regards,

kartik

Re: Columns graph and lines graph in the same chart

Former Member — Mon, 13 Feb 2012 06:52:15 GMT

Check FM GRAPH_MATRIX_2D and

Program GRAPHICS_GUI_CE_DEMO for the same

Re: Columns graph and lines graph in the same chart

Kartik2 — Mon, 13 Feb 2012 07:04:48 GMT

Dear Mr. Kaushik Datta,

Thank you for your quick reply. But I want my chart to be in a custom container so i am not using the Function Module suggested by you. In using the class CL_GUI_CHART_ENGINE. For multiple data series we can show all the data series as colums or Lines, but my requirement is to show one series as columns and the other series as Lines overlapping on the columns.

How can i achieve it ??

Regards,

kartik

Re: Columns graph and lines graph in the same chart

Former Member — Mon, 13 Feb 2012 07:32:38 GMT

Hi ,

Somewhat I have understood your requirement. Report GRAPHICS_GUI_CE_DEMO is also using a custom contain and columns and row are populated by using "if_ixml_node~set_value".. check if you can use these logic for the same.

Re: Columns graph and lines graph in the same chart

Kartik2 — Mon, 13 Feb 2012 07:52:01 GMT

Hi,

I have gone through the Standard demo program GRAPHICS_GUI_CE_DEMO. But i did not find how to assign different chart types to the charts displayed in a single container.

Thanks and regards,

kartik

Re: Columns graph and lines graph in the same chart

Kartik2 — Mon, 23 Apr 2012 03:13:18 GMT

Dear All,

Achieved this using Class CL_GUI_CHART_ENGINE. There is a provision to add multiple series, and we have to name each and every series, i have named first series as 'Series1' and second series which is to be displayed as line as 'Series2'. Now the following is the customizing that is to be used in the customzing xml that is being set to instance of Cl_gui_chart_engine.

...

</Series>

<ChartType>Lines</ChartType>

</Series>

The follwing is the chart obtained -

Thanks and regards,

kartik

Re: Columns graph and lines graph in the same chart

Former Member — Mon, 26 Nov 2012 09:46:20 GMT

HI Karthik,

This is Mahesh E C .

I have a same requirement as you explained above. I am preparing an Inventory Graph for one of my clients. Here I have a requirement to display the graph with respect to the Target and Actual. Currently I am using CHART ENGINE and TRANSFORMATIONS to achieve the above.

I have 5 data series and I am using the Chart Type "StackedColumns", in which the Planned data should be displayed as a line . I tried using the method you have mentioned above .Like in the Customizing XML I have written the below tag. but it doesn't working. It would be very helpful if you could help me on this?.

<ChartType>Lines</ChartType>

</Series>

Whole code in Customizing XML.

CALL TRANSFORMATION zce_customizing
SOURCE title       = 'TITLE'
category_axis_title = 'category_axis_title'
value_axis_title    = 'value_axis_title'
colorpalette        = 'Streamline'
chart_type1         = 'StackedColumns'
RESULT XML customizing_xml.

<?sap.transform simple?>

<tt:transform xmlns:tt="http://www.sap.com/transformation-templates" xmlns:ddic="http://www.sap.com/abapxml/types/dictionary" xmlns:def="http://www.sap.com/abapxml/types/defined">

<tt:root name="CHART_TYPE1" type="?"/>

<tt:root name="TITLE"/>

<tt:root name="CATEGORY_AXIS_TITLE"/>

<tt:root name="VALUE_AXIS_TITLE"/>

<tt:root name="COLOR_1"/>

<tt:root name="COLOR_2"/>

<tt:template>

<Dimension>three</Dimension>

<tt:text>Tradeshow</tt:text>

</ColorPalette>

<tt:value ref="CHART_TYPE1"/>

</ChartType>

</Defaults>

<ChartType>Lines</ChartType>

</Series>

</GlobalSettings>

<Title>

<tt:value ref="TITLE"/>

</Caption>

<Text>

</Text>

</Title>

<Title>

<tt:value ref="VALUE_AXIS_TITLE"/>

</Caption>

</Title>

</ValueAxis>

</ChartAxis>

</Elements>

</SAPChartCustomizing>

</tt:template>

</tt:transform>

Thanks in Advance.

Mahesh E C

Re: Columns graph and lines graph in the same chart

Former Member — Sun, 19 May 2013 09:37:16 GMT

Hi Karthik,

I have got the same requirement ( Column + Line in a single Chart ), I have added series id in the chart customizing as mentioned by you, but i am unable to get the required output.

I am getting only columns. 'Lines' chart type was not respected for that particular series.

Do i have to add any more to get it done?

Thanks

Santosh

Re: Columns graph and lines graph in the same chart

Former Member — Sun, 19 May 2013 11:51:39 GMT

Hey Karthik,

I have resolved my problem on my own. I made use of ChartDesigner.

Also , I have created a detailed document about chart engine usage & trouble shooting. Hope it will be useful for those,who face problems in using SAP GUI CHART ENGINE.

http://scn.sap.com/docs/DOC-41635

Thanks

Santosh.