cancel
Showing results for 
Search instead for 
Did you mean: 

Addition of serie in line or pie chart

Former Member
0 Kudos

hi

I have 2 key figures in my query.

I have assigned this query as my data provided in my chart (line and PIE charts)

I want to do a comparison of these 2 key figures in a single chart.

How do I assign the 2 series to these 2 KFs ?

Thanks !

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Go to Edit properties in chart.

Then You can find no of series ad categories.

Increase the number of series count to 2.

Regards

M.A

Former Member
0 Kudos

hi

i did. but how do I assign say serie 1 to KF 1 and serie 2 to KF2 ?

Former Member
0 Kudos

Hi

By default 1 st keyfigure will be assigned to Series1 and second will be assigned to Series 2.

So you have to have only two keyfigures to be displayed in report. You can hide the other unwanted keyfigures.

Regards

M.A

Former Member
0 Kudos

hi

I have 3 KF. How do I hide the unwanted one ?

Does the same applies to a PIE Chart ?

Former Member
0 Kudos

Hi

If you have three keyfigures then Right click on the keyfigure which you do not want to display in the Pie chart and Select properties on the right top you can see the option ALwas show/Always hide/Hide can be shown.

Select the Always Hide option for the keyfigure which you do not want to display in Pie chart.

No need to do anything in Pie chart,

Regards

M.A

Former Member
0 Kudos

hi

tks.

I mean i do the same for PIE CHART ? I need to display 2 KFs in a single PIE Chart.

Former Member
0 Kudos

Hi

1. Hide the unwanted keyfigure in Bex report,

2. Sort the keyfigure first and second in the way you want to display as Series1 and Series2.

3. In Pie chart have two series alone.

No it will display what you need.

Regards

M.A

Former Member
0 Kudos

hi

i have 3 KF in my Query.

in first chart, I want to compare KF 1 and KF3.

In 2nd chart, I want to compare KF2 and KF3.

Can i do that?

Former Member
0 Kudos

Hi

No it is not possible.

Part1:

If you want to compare 1 and 2 in fisrt chart then

hide the third keyfigure in the report.

web template:Create data provider1 and assign this report to the dataprovider1

Part2:

If you want to compare 1 and 3 then hide the second keyfigure,before that make the copy of the report and assign new name for it.

webtemplate:Create Data provider 2 and assign the report 2 to the Data provider2.

Regards

M.A

Assign points if its helpful.