How to plot chart show sales and debt in one chart ?

[paulyeo11]

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 ?

[paulyeo11]

Enclosed my QS doc.

[#3]

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

[jagan · Accepted solution]

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.

[paulyeo11]

Hi Jagon

Thank you for your reply. it work for me.

Paul

[jagan]

Hi Paul,

If you got the answer close this thread by giving Correct & Helpful Answers.

Regards,

Jagan.