anyone have any ideas on how to match scales of overlaying charts so that everything lines up properly? I’m creating a stacked combination chart and want a line graph overlaying it to match.
Thanks for any help
taleonard (BOB member since 2007-06-11)
I too came across this issue recently and here is what helped.
Use a manual scale with max and min (if you require min to be different from 0) coming from the table values.
Also, used fixed number of divisions.
I have some points noted down in the attached sample in case it is of any help. I see there are many minor tweaks and if we miss out one then it would not work very well.
Thanks,
Stacked Combination chart.zip (10.0 KB)
Naresh Ganatra 
(BOB member since 2004-04-09)
thanks for posting this information. i was just looking for the same thing and had asked about it over on the SAP forums. your solution will work perfectly for what i want to do!
HondaTiger (BOB member since 2005-03-31)
hi Naresh,
how do I get rid of the numbering on the linear line? it display it for some reason when i do the mouseover. this is a good example but mine moves my stack column chart off alignment with the combination chart, any ideas?
cssanangeles (BOB member since 2009-07-30)
for the alignment you need to have the exact same display for both the charts
for eg
if you are formating one you have to make sure u apply the exact same format for the other chart also.
I am not sure what could be the exact problem you are facing.
If you can post you xlf file or a screen shot I might be able to tell you.
Naresh Ganatra 
(BOB member since 2004-04-09)
hi, see screenshot, see the gp mouseover? ok i’ll keep playing with alignment…
example.doc.doc (137.0 KB)
cssanangeles (BOB member since 2009-07-30)
for your alignment, I think the issue might be that you have axis lables displayed for one and removed/hidden for the other chart ?
you need to display the axis labels for both the charts and that way they will be exactly same and will overlay. diplaying the labels for both charts will make sure that you chart height and width are the same.
for the mouse over, I am not sure if I understand the requirement yet.
Are you saying that you do not want to display mouse over values or that you do not want to display one part of it ?
Naresh Ganatra (BOB member since 2004-04-09)
yes the axis was not on one, i’ll fix that
on the mouse over, i want the percent on the gp, but it has a number which i think comes from setting, how do i get rid of 9 for example?
cssanangeles (BOB member since 2009-07-30)
The 9 actually is your X-axis label , I am not aware of a way to partially change the mouse over values. You can either hide mouse over or you can display the same fully.
One option is to use the mouse over values as in the file that I have attached with this reply.
But that would actually remove your category x aixs label and would have to do some work to get back the alignment.
But if you find another simple way out do let us know, would be intresting.
Thanks,
Mouseover.zip (14.0 KB)
Naresh Ganatra (BOB member since 2004-04-09)
thank you, i fix the 9 when i put back in the x axis on the missing one. but my alignment will not match still. I think its because i have two different y axis, it has to be different since one y represent different scale, is there a way around this? thanks again
cssanangeles (BOB member since 2009-07-30)
Naresh, can you tell why my stack column is not showing up?
example.doc.doc (144.0 KB)
cssanangeles (BOB member since 2009-07-30)
The background of the chart that is in the front should not be shown.
ie, in Appreance >> Layout
Show Chart Background should be unchecked.
That way the chart behind will be visible.
Looks like that might be your issue.
Thanks,
Naresh Ganatra (BOB member since 2004-04-09)
ok this is frustrating, my thing came out buy my axis for the line don’t line up with the axis on the stack, why is that? both are utilizing the same x axis…
Is there another software from business object that have a component with stack bar and line that can be easily use? this one is such a waste of time.
example.doc.doc (231.0 KB)
cssanangeles (BOB member since 2009-07-30)
ok this is frustrating, my thing came out buy my axis for the line don’t line up with the axis on the stack, why is that? both are utilizing the same x axis…
Is there another software from business object that have a component with stack bar and line that can be easily use? this one is such a waste of time.
my shot of one on the right is how the line is suppose to look but using the two graphs is so tedious. help
example.doc.doc (231.0 KB)
cssanangeles (BOB member since 2009-07-30)
What are you doing for the divisions ?
Have you checked at having fixed number of divisions for both the axis. Say 5 or 10 divisions ?
I have not tried doing one with 2 axis before so not sure of any other pit falls you might come across.
If you are able to attach the xlf file then I might be able to look at it.
Regards,
Naresh Ganatra (BOB member since 2004-04-09)
thanks I got it fix, it was still tedious to do
cssanangeles (BOB member since 2009-07-30)