Legend not always showing on stacked bar chart until I click it

[#1]

Hi Community,

Can someone help me understand why my legend doesn't always show on my stacked bar charts until I click it.

When I create the chart it looks like this:

The legend is missing. But then when I click somewhere on the chart, it shows up.

When I click around outside the chart, it goes away again. Is this because the legend is too long? I tried shortening it and didn't run into the issue. Example attached.

[#2]

This may clear up the issue, but it changes the location of the legend. I wanted the legend on the bottom.

[Chanty4u]

cooool 

u can chnge that usng cntrl+shift i thnk am nt sure

[#4]

Unfortunately, that's how I got the legend on the bottom in the first place. Resetting those and then putting on the bottom the problem comes back.

[Chanty4u]

yes of course.  so u can create other chart on that top of the chart and make it as transparent  

may be it helps u

[swuehl · Accepted solution]

Jesse Unger wrote:

Thanks Stefan,

Is there a way to know how big is big enough? The bigger I make that, the smaller is the chart area. I see that if I keep adding characteristics, the legend turns into a scrollable box in any case...

Jesse,

since you asked for a way to know how big is big enough: I don't know it. It's always a little bit of fiddling around when changing these legend settings and positions.

This effect you've seen when clicking around seems to be more a bug than a feature to me. If you can't increase your chart size, I think using a legend in a chart this small is not really user friendly.

Maybe consider removing the legend completely from the chart and display all dimension values and their color in another object, like one legend for the complete sheet.

I remember a blog post here in the forum on how to do that, but just can't find it right now.

Regards,

Stefan

[#7]

Hey Stefan,

I think you're right that it's a bug and probably needs a workaround. I can try to have defined colors for these charts and reference them elsewhere. I'm marking your answer as correct since it's the most correct but again, this feels more like a bug. Thanks for your help.

[swuehl]

Here is a blog post of what I've had in mind:

Use of a Silent Legend