interactive charts for stacked bar charts

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
 
J

Jon Peltier

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
 
J

jccantu

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.
 
J

Jon Peltier

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top