benzene | ⌬ Fast , minimal , agnostic GraphQL Servers | GraphQL library

Edit: Using hovertext instead of text and textposition = "none" (also see this related answer)

Add to the end of your string in the hovertemplate field. For example, hovertemplate = "Chemical Name: %{x}
Available Amount: %{y}
Department: %{text}"

Just remove the concatenation (c) in group_by

One option would be to aggregate your data before plotting:

plotly doesn't understand when back ticks are surrounding the variable name that it's still a column in the data. (With regard to the hovertext, specifically.) There are a few ways to get around this. Since you're still using the x and y of each trace, you can use hovertemplate instead.

updated

After I posted this answer I noticed that 2500 looked the same size as 4000 and that's not quite right. From there I recalled that plotly won't aggregate the totals. You can aggregate before or during, but it won't automatically sum the values.

Also, the function aggregate won't accept variable names in back ticks, either.

I've updated the code here to aggregate the totals so that your hovertext shows the total by group, not individual layers as you move your mouse down the column.

I added x and y labels in the call to layout, because the backticks were in the graph.

We may need to join (left_join) and then mutate to create the column

Here is one way that should work with your input data:

This worked for me:

I think you can switch the positions of B and C when you create the plotly.express figure. Then switch the titles as well.