Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below 2 bar chart , i like to combine both bar chart into 1 bar chart , so that i can view their sales vs debt amount in one chart. it is possible in QS ?
Hi Paul,
I think you don't need to use two different axes for two expressions because both the expressions is having the near values, also it would be confusing to users if you use two axes. You have to go for two axes if you are comparing Percentages and Numbers or Sum(Sales) and Count(Salesman) like this.
Hope this helps you.
Regards,
Jagan.
Enclosed my QS doc.
Hi,
You can have both charts in the same chart
step1->goto->new sheet object->chart object->click on bar chart as shown in figure1->enter the 2 expression in the expression tab as shown in figure2->then go to axes tab for sales click on position as shown in figure 3 and for Depth click on position as shown in figure 4.
figure1figure2figure 3figure 4
Hi Paul,
I think you don't need to use two different axes for two expressions because both the expressions is having the near values, also it would be confusing to users if you use two axes. You have to go for two axes if you are comparing Percentages and Numbers or Sum(Sales) and Count(Salesman) like this.
Hope this helps you.
Regards,
Jagan.
Hi Jagon
Thank you for your reply. it work for me.
Paul
Hi Paul,
If you got the answer close this thread by giving Correct & Helpful Answers.
Regards,
Jagan.