You can't use a dynamic range to alter the number of series in a chart, only
the number of points in each series.

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


wrote in message
ups.com...
I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU