interactive charts for stacked bar charts

  • Thread starter Thread starter jccantu
  • Start date Start date
J

jccantu

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
 
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.
 
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
 
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
 
Back
Top