Customizing labels on a chart

#1

Hey all! :wave:

I received a great question today about how to customize the labels on a chart. For example, if you want the pie chart labels to include both the category and the percent, without needing to hover. There isn’t currently a specialized builder for customizing chart labels, but there’s another easy way to get whatever info you want into your labels!

  1. create a new column which will contain the full text that you want to exist in your label. I’ll just call it “Label”.
  2. In the “Label” column, you can create a formula that puts together all the info you want to include in your chart label. For example, here I calculated the percent in its own column and then used the Format() formula to combine the Name and the Percent into one text label value, like this:


(Note: There are a few ways to combine text together, so use whatever you feel comfortable with. You could use the Concatenate() formula, Concatenate([Name], ' - ', [Percent of Total]), or even just the plus sign: [Name] + ' - ' + [Percent of Total]. All our text formulas are here in the full formula list if you want more details!)

  1. In your chart settings under Category you can now select the shiny new “Label” column instead of the default column, and the full label you created will show up in the chart labels. :heart_eyes_cat:

Check out this example doc to see it in action. Screenshot below!

What other types of info do you put in your chart labels? Any other creative formulas you’ve used to summarize multiple pieces of info in one place? :smiley:

Moriah
moriah-square


7 Likes
#2

Moriah, thanks a lot for your quick response, it´s great and i think it was just what i asked for! i´ll check it out and let you know. Chears.

1 Like
#3

Hi @Moriah,
How do I achieve the same thing for bubble charts?

#4

Dear @Francesco_Pistillo,

See pic below, but I assume that you expect the text to be next to the bubble, isn’t it?

#5

Hi @Jean_Pierre_Traets,
Exactly! When I have different sizes and quite a bit bubbles a similar label like the pie chart would come in handy to understand the exact number of the bubble/circle.

The thing is a little tricky tough cause it’s hard to find space for labels when my chart starts to be complicated, :