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

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

just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
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

This would leave a legend entry, even if the series had no points.

What I do with this kind of series is point to an empty range, rather than
try to define a range of zero cells.

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


wrote in message
oups.com...
just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
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

To hide a series and legend entry, you could set up an autofilter (if the
series were arranged by row in the worksheet), and use the autofilter to
hide rows you didn't want to plot.

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


"Jon Peltier" wrote in message
...
This would leave a legend entry, even if the series had no points.

What I do with this kind of series is point to an empty range, rather than
try to define a range of zero cells.

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


wrote in message
oups.com...
just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
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