I'm not clear on what you want to do, but you might check out Jon Peltier's
site to see what he has on Stacked Charts.

http://www.peltiertech.com/Excel/Charts/index.html

wrote in message
ups.com...
Ok, I am trying to make a stacked chart that starts at points other
than zero but can still have the data label show the actual point.
Even more complicated is I would like to have a label that is based on
a point somewhere in the range of the stack.

Here is a sample of what I am looking for:
The start point mid point and end point I want to display the stacked
chart a
10
15
20

Currently I just use 10,5,5 as my data for the chart and then just hide
the first column in the stack (0-10).
I would like to be able have the very bottom stack start at 10 so that
there are just two stacks in this data plot, 10-15 and 15-20.
Then I sould like to be able to plot on the stacked chart a seperate
data point that is somewhere in the range - say 17.5. This data point
will change so really this chart is kind of a slider chart.

I have been messing with this one for a while now and am just stumped.
Any help is greatly appreciated.

Will