Different Data types Measures on the same position in the bar Chart

[#1]

Hi,

Is there a way to get two bars with different data type positioning at the same point,

below is my requirement:

Category 1 and Category 2 are in Numbers

Category 1 % is in percentage data type, I want this to be positioned at the same as Category 1.

Category 1 % is the percentage of work completed, hence Bar background color is based on the % which is 91% for Jun.

Your help is very much appreciated.

Thank you!

[Anil_Babu_Samineni]

How about this?

[antoniotiman]

Like this ?

[jmvilaplanap]

Hi,

You can do it easily overlapping two graphs, here you have an example

Really are two different graphs in the same place (one with bars and another with lines)

[afsarshaikh]

Goto Chart Properties > Style > Try the Subtype Stacked.

[#6]

Hi Antonio, Thanks for the reply.

Yes, that's what I'm looking for, can you please share the QVW file?

Thanks, Sri

[#7]

Hi Anil, thanks for the reply.

Yes, I'm looking for similar to what you have shown, only difference is green bar should be on %.

Like ID1|2013 Blue bar has 40, and second green measure should in % of completed out of 40.

Thanks

[antoniotiman]

See Attachment

[#9]

Hi

I tried applying your logic; it looks good however % bar height is not appropriate.
I’m expecting that if % is 100, then height should be as Category 1 and accordingly.

Like in the given example, for Jun 2017 orange color should have covered 89% of 186.

[antoniotiman]

This is an exemple.

I don't know Your Data and Logic.

Provide Your Data and expected result.