• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Christmas Trees with Multiple Data

A

Aramina

New Member
Hi,


I have a data table which shows the number of employees by pay band, and am displaying this in a 'Christmas Tree' type bar graph. (So 0 on the horizontal axis is in the middle of the graph, and the bars are of equal lengths on either side).

However, I now need to show this data split by Gender as well, but still in the same Christmas Tree format.

I've tried changing the Female numbers to minus ones, and this gives a Christmas Tree of sorts, but its a very lop-sided one.

How do I get the bar graph to display so it looks balanced and the bars are of equal length either side of the 0 on the horizontal axis, but are still showing the number of Male/Female employees within the bar?


Many thanks
 
Perhaps this article will be helpful?

http://peltiertech.com/WordPress/tornado-charts-and-dot-plots/


Shows how to create said chart, specifically with male/female distribution, and presents several other solutions.
 
You must log in or register to reply here.
Back
Top