Hide series data labels?

Originally Posted by spence425

i have a stacked bar chart with series data labels for each set. i am not displaying value data labels. How can i hide the series data labels if there is a zero value for that series?

in the simplified example attached, you can see that Cami only ate dinner, no lunches. but the stacked bar chart still shows the series label of "lunch". i would like it to not show that label, but be dynamic enough that i can later pull in new data and have the "lunch" label appear if she has eaten (say for example this chart is updated on a monthly basis using vlookups)

Hi,

If you record a new macro and then select a couple of data point labels and 'Clear' them, then re-select those points and re-set the Label to Series Name this would give you an idea of the code required to achieve this.

Set code similar to that within a loop that tests each data point for = zero and Clears or Restores the labels.

As you will see, it's not a simple task and you would need to evaluate the effort required for the return gained.

hth
---