Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Interactive Chart Tool: add data labels to bar chart?

kelly_gilbert
13 - Pulsar

Is it possible to add data labels to a bar chart in the Interactive Chart Tool? This was possible in the deprecated Charting Tool, but I can't figure out how to add labels in the new Interactive Chart Tool.

 

I see that there is an option to add labels for a pie chart, but can't find that option for a bar chart.

 

The chart I'd like to replicate is something like this:

Bar chart with labels.png

Thanks!

 

18 REPLIES 18
JohnMaty
9 - Comet

Has there been an update to this functionality?  This is an incredibly frustrating shortcoming of the tool!

apolly
Alteryx Alumni (Retired)

Hi John,

 

I'm sorry this is so frustrating for you and we recognize the lack of functionality and it's usefulness/necessity. This is a high priority for us and I will update you when we are able to make this feature available.

 

 

Thanks,

Alex

alison
7 - Meteor

Add my vote to this as well. This seems like a pretty basic/ obvious reporting need.

apolly
Alteryx Alumni (Retired)

Hi, Apologies I did not update this thread. We updated a number of threads that had this request but missed this one. Sorry for that.

Now in 19.3 Designer release, you are able to add labels to charts. Please download the latest release and let us know how you like this functionality. You will find it on the Style>Layer page.

 

 

alison
7 - Meteor

That's awesome news! I look forward to playing with it. Thanks for the update!

klaudia1204
5 - Atom

@mlehar this has been corrected in 2019.3 designer version. You can define labels in the Interactive Chart configuration.

 

klaudia1204_0-1572515392836.png

 

-Klaudia

 

efurlow
5 - Atom

I am a little frustrated the functionality. 

Attempting to have outside labels and an automatic chart width for repeat ability's sake. And it keeps cutting off my labels. Any insight in how to solve this issue? I don't like the look of auto labels because some of them are flipping sideways and are difficult to read

efurlow_0-1572899454648.png

apolly
Alteryx Alumni (Retired)

@efurlow I will mess around with the auto-labeling when the bars at different widths and work with the engineering team to understand what options we have available to us. I'm sorry for this frustration and will look into this experience. Please reach out with additional thoughts.

kelly_gilbert
13 - Pulsar

@efurlow - I know this is a late response, but in case it's helpful to you or someone else...  We're still on 2019.2 in my org, so I can't try out the new labels yet, sadly... I can't wait!

However, we do sometimes want to add some horizontal buffer to a chart for aesthetic reasons. Maybe this work-around would help give your labels enough space?

 

I add a second layer to the chart, using a value that is larger than the largest bar. That forces the x-axis to accommodate the new, larger value, and creates space between the largest bar and the right side of the chart.

 

  1. Find the max value in your data
  2. Add some buffer (for example 40%) to the max value. You could also use a specific value (e.g. [max_value] + 500).
  3. Create your bar chart as usual
  4. Add a second layer to your chart (a scatter plot). For the scatter plot, set Y = your category field, and set X = the max value + buffer that you created in step 2.
  5. You can make the scatter layer invisible by either going to Layer settings --> un-check Show: Points or by changing the color to the same as your background.

 

Without buffer

kelly_gilbert_1-1576534557120.png

 

With buffer

kelly_gilbert_3-1576534735810.png

 

 

Labels