Customizing labels on a chart

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

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

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

Dear @Francesco_Pistillo,

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

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, :

Awesome- Kind of working for me, but my labels are getting cut off. See pic

i really need label to be shown without having to hovering each of the data point one by one. its just not intuitive and a waste of time ;(
the formula seems too much of an extra step…when will this be implemented??

2 Likes

Hey folks :wave: Just wanted to follow up on this thread. We’ve recently launched the ability to add data labels to charts (including bubble charts). You can now toggle data labels directly from the chart display menu. Hope this helps!
Screen Capture on 2023-06-09 at 09-37-26 (2)

3 Likes

Hi!

I have the same issue, although I find the button with “label” in my bubble chart, but cannot find where I can customize which column from my table should be the label in my bubble chart.