on 10-23-2014 9:15 AM
I have 2 values, one for how many people are active at the company and one for how many people leave per quarter.
It looks like this
1200 0
1195 5
1180 15
1173 7
1166 7
Now I can make this chart in Excel but is it also possible to create a line chart over a column chart within sap?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried this but everytime I check the box for visability on the second axis, it uncheckes it automatically after I save.
This is how the chart looks like
Do you have any ideas about what goes wrong?
/edit: Also how do I specify what value need to be used for what series? Because it looks like that's going wrong, it just creats 2 column charts for the data
Hi Yasemin,
You were right about the query I changed the rows and columns and now the query displays correcty
The only thing that's not working now is the second axis.. this is how the chart looks and how the settings look
When I check the first box, and hit finish and open the the dialog again it's back to unchecked
Hi Yasemin,
I have still something that I don't get to work. Showing up the second axis. It now uses the secendary axis but it doens't show it. Everytime I check the box for visibility it uncheckes it, the same goes for the primairy axis if I uncheck the box so it won't show, the box just gets checked again.
There was however one moment where I checked the box for the secondairy axis and it appeared! So I know it is possible but I just don't get why it doesn't want to show up, maybe you could help me with the settings?
/edit The axis aren't the only things that don't changes I have found more settings that I can't change like the type of diagram, it just changes it back anyone know what causes this?
It askes for a password and username?
But since you know your way around the WAD and reply so quickly (thanks for that!)
maybe you know if this is possible;
I have a dashboard with 6 charts, now I'm asked to find a way to quickly switch the graphs between absolute numbers and percentages. I made two key figures in the querys already and was thinking about a button in the dashboard that switches the filter value to percentages.
Is something like this possible and if it's not all that much trouble can you tell me how?
PS I found a workaround for the chart with 2 axis I deleted the old chart and made a new one and for some reason the new one lets me add the second axis.
Hi Bart,
What comes to my mind right now is; you can create 6 more charts with percentages shown. And you can create a dropdown and add two options (Percentage, Value) then you can add commands to make the first 6 chart invisible and others visible for values, and vice versa for the second row in the dropdown. This will be easy to do.
Hope it gives an idea.
Regards
Yasemin...
Hi,
it is possible with BEx WAD and SAP BO- WEBI tool.
in BO -WEBI take the line chart and add the series units slod and total transactions.
after check the out put.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bart,
Yes this is possible. Select a line chart for this.Add two series. Then select Series1 in the wizard, select graphic type as lines, and the axis as primary. Then select Series2, select graphic type as columns and the axis as secondary. That is all. It will show the way you want.
Regards
Yasemin...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bart,
what do you mean with "within SAP"?
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.