I am working on a spreadsheet comparing the median sold $ to the average sold
$. I want to show this data in a column chart, the primary x axis is price,
the y axis is by month. Since I have 2 values for each month, I want to
display the data on one column per month, with the column color-coded and
"split" so the user can tell which is which. for example, the median sales
price in Dec 04 is $181,900, and the average sales price is $237,000. I would
like the lower value (the median price) first, with the higher value (the
average price) making up the different between $181,900 and $237,000. Right
now my chart is stacking both values, for a total of $418,900.

Does anyone know how to do this? I know it can be done because I am looking
at a hard copy that I am trying to duplicate. Any help would be greatly
appreciated.

Carly