CODEWITHSUNDEEP
google-sheetsbar-chartstacked-chartcolumn-chart
Andrew Frye
Andrew Frye

Reputation: 31

How to get bar chart data label to display both value and percent (of total) in google sheets?

In a 100% stacked bar chart, how can I get the data label to display BOTH the value AND the percent of total? Example: 129 (60.3%)

This is displayed in the tooltip when you hover over the bar, but not visible on the bar itself.

Example here: https://docs.google.com/spreadsheets/d/1qpro5WMBxOljwshoDFXsqC5_XFz-aF8dlfgMxdCINp4/edit#gid=796957633

Upvotes: 3

Views: 42646

Answers (1)

Mateo Randwolf
Mateo Randwolf

Reputation: 2870

Workaround

Unfortunately, at the moment of this answer it is not possible to add multiple data labels. However, you can create you own label by inserting an annotations column next to each data point. The content of these annotation columns would be your desired label. Then you would just need to add these labels as described in the reference I just shared.

In your case it would look like 129 (60.3%) which you could obtain from the following Google Sheets formula : = C4&" ("&ROUND(C4*100/($C4+$C5+$C6),1)&"%)").

Upvotes: 1

Related Questions