6 Replies Latest reply on Sep 25, 2013 11:38 AM by . Indumon

# need a 'combined bar' graph

I am looking for a way to display sort of a combination of a bar graph and stacked bar graph where they all start from zero and overlap - most similar to the 'circle views' only with bars.  there is an example of a nearly identical kind of graph at http://projectpophealth.org/images/Single_Provider_Dashboard_Page.png

In this graph, there is a total population bar which is the largest, a denominator bar which is only those who met the necessary characteristics, and the numerator bar which are those that had all of the measure criteria, but all are displayed within each other.

On my workbook I can stack them on top of each other, show them next to each other or have overlapping shapes, but none of these achieves my ideal graph.

• ###### 1. Re: need a 'combined bar' graph

Hi Michael,

Please attach packaged workbook (.twbx) so that we can understand your problem more clearly. However, you can create a calculated field in which you can break a total population in different parts(like numerator, denominator etc.) & color them accordingly to those fields.

Warm Regards,

Prashant Sharma - India | LinkedIn

1 of 1 people found this helpful
• ###### 2. Re: need a 'combined bar' graph

Hi Michael,

From your sample I guess you are looking for a solution which can be achieved by a Dual graph.sample workbook also attached

• ###### 3. Re: need a 'combined bar' graph

Indumon, that looks exactly like what I what like to do, only I can only combine two of the numbers into the same axis, I would love to see the workbook but I don't see it.  How do you add a third measure to the axis?

• ###### 4. Re: need a 'combined bar' graph

You can combine multiple measures in same Axis.However in this case Numerator and Denominator measures are added in one axis and created the stack chart.

Then add the Total Population as dual axis ( drag it to the column) then right click and choose dual Axis option.

1 of 1 people found this helpful