Ok David, I did as you and Jon advised. Now I have two columns of the data,
and I would like the data "stacked" on one column as described in my original
post (below). How do I go about doing this?

Again, thank you for your help.

Carly

"David Biddulph" wrote:

Regulars in this group will be amused at you telling Jon (of all people)
that he is wrong.

You need to read again what he said.
He said select the CLUSTERED column subtype of the column chart.

By the sounds of your symptoms, and how you have described them, you have
selected the STACKED column subtype.

Would you like to try again?
--
David Biddulph

"Carly" wrote in message
...
Hi Jon

Thank you for your advice. However, I looked into your recommendation and
I
don't think this is correct. This option simply stacks the 2 values on top
of
the other, whereas I would like the column height value to be the greater
of
the two values, not stacking the values. Any other suggestions would be
greatly appreciated. I am doing this for work and it is taking me too
long!

"Jon Peltier" wrote:

Select the clustered column subtype of the column chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Carly" wrote in message
...
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