K
KMH
I would like to have Excel automatically exclude the series label on a
stacked column chart if the value associated with it is zero. I can use the
0;0;;@ custom number format to make the values themselves disappear in the
data labels but I don't know how to automatically turn off the series label
along with it.
For reference, I am plotting 2 columns next to each other -- one where costs
stack up (upcharges) and then another where costs are shown coming back down
(savings). For each element, data is only shown in 1 column or the other,
but they can move from one column to the other so I don't know which column
they will be in and I want my chart to automatically make the adjustments.
In the end, I will have several pairs of these columns where the series
labels could all be different for each set and I don't want to use a huge
legend key -- I want the label to show (or not show) on the stack as needed.
Thanks
stacked column chart if the value associated with it is zero. I can use the
0;0;;@ custom number format to make the values themselves disappear in the
data labels but I don't know how to automatically turn off the series label
along with it.
For reference, I am plotting 2 columns next to each other -- one where costs
stack up (upcharges) and then another where costs are shown coming back down
(savings). For each element, data is only shown in 1 column or the other,
but they can move from one column to the other so I don't know which column
they will be in and I want my chart to automatically make the adjustments.
In the end, I will have several pairs of these columns where the series
labels could all be different for each set and I don't want to use a huge
legend key -- I want the label to show (or not show) on the stack as needed.
Thanks