Thanks EC, this works great :)

"Excel Curious" wrote:

Ok here goes...

Data:
Column(A) = count
Column(B) = payscale
Column(C) = count x payscale
Column(D) = Column(C) / 2
Column(E) = Max column(D) - column(D)

Chart:
Select a Stacked Bar Chart
Series 1 = Column(E)
Series 2 = Column(C)
Make the fill on series 1 = no fill

"ArcticWolf" wrote:

Hi,

I have a table that lists employee names and their payscale. I want to put
this into a Christmas Tree chart (as a count of people per payscale) but
cannot find a 'chart' in Excel that will do it. I've seen them around and
would like to know how it's done.

I would also like to add a third variable (ethnicity) so will have the
chart: number of people in payband split by ethnicity.

Christmas Tree charts are similar to horizontal bar charts but are
'mirrored' on the opposite side. Here is a link to picture of what I mean.

http://tinypic.com/r/245ijhj/3

TIA,

AW