I’m working on a pie chart in Google Sheets and I’m having trouble with the display options. I can easily show the actual numbers on the pie slices themselves, but that’s not what I want. I prefer to have percentages displayed on the slices since they fit better in smaller sections. What I really need is to show the actual numeric values underneath the legend labels instead of just percentages. I’ve tried different formatting options in the chart editor but I can only get percentages to appear under the labels. Is there a way to customize this so the legend shows both the label name and the actual value while keeping percentages on the chart slices? Any suggestions would be helpful!
Here’s what worked for me - I ditched the automatic legend completely and made my own. I disabled Google Sheets’ built-in legend and created a separate table next to the chart with category names and raw values. This way you control exactly what shows up where. Set your pie slices to show percentages only, then pull the actual numbers into your manual legend table using the same data range. Takes more setup time upfront, but the control is totally worth it if you’re putting this in reports where exact numbers matter. Just remember to update your manual legend when the source data changes.
totally feel ya! it’s a pain with google sheets not showing both values and percentages. manually editing legend labels is def a workaround but super time-consuming. wish they’d make it easier for us, lol!
Had this same problem last month doing quarterly reports. Here’s what worked: Go to the chart editor’s “Legend” section and switch position to “Bottom” or “Right” first. Then hit the “Series” tab, find the “Format” dropdown, and change it from “Percent” to “Number”. This shows raw values in the legend but keeps percentages on the actual slices. You’ll probably need to refresh the chart after. The trick is that series formatting and slice label formatting are separate settings - that’s why you have to change them individually.